To get back to the original question - Andy, go to your public library and either get a songbook (try the 780's, esp 784) or check out CD's with traditional songs.

I tried to think of what you specifically requested, ballads which does not involve tragedy, but I couldn't think of any. However, if you like singing, I am sure you will find songs to your liking at the library.

The important thing is to get started - to find songs and to meet people.