There are three copies of the tune available through the webwide ABC index. I've seen it called "The Drunken Piper of Galloway". Galloway isn't a Gaelic speaking region, and the title isn't Gaelic. I doubt there are any original verses to it in any language.