I recommend the Pogues 'Sick Bed of Cuchulainn' from their album 'Rum, Sodomy & The Lash' if you want a rollicking good Irish drinking song with some folklore thrown in. Its long been a favourite of mine.