When my lovely mate John Flaherty died a dozen years ago, I adapted the old song "He Was A Friend Of Mine" to sing at a couple of memorial gigs and other places.   You can alter the words to suit the person in question.   E.g.

He was a friend of mine x2
If he ever had any money
it went on whisky beer and wine
But he was a friend of mine

and so forth