I can't drink anymore, but for drinking songs of the Celtic variety, it would be really hard to get much better than the Clancy Brothers.

Some of my faves:
Cruiscin Lan
Pub With No Beer
Whisky, You're the Divil
Juice of the Barley
Finnegan's Wake
Maloney Wants a Drink
Mountain Dew