If not everyone's into irish music Parting Glass is perfect. Lovely tune, simple lyrics, genuine feeling. 2nd verse is most poignant of all:

If I had money enough to spend
And leisure time to sit a while
There is a fair maid in this town
That surely has my heart beguiled
Her rosey cheeks, her ruby lips
In truth she has my has my in thrall
But fill to me the parting glass
Goodnight and joy be to you all.

(Corrections / alternatives welcome)

I'd forgotten about this song and I'm playing a wake tomorrow, cheers mate.