For a hymn I can find little better than O Love that will not let me go to the tune of St Margaret.

Or, for the wake, "The Parting Glass"

CHEERS
Nigel