This is a traditional tune, that goes by many names Some are based on the number of verses, typically between four and seven nights drunk. Alternate names include (but are certainly not limited to Our Goodman, and You Old Fool.

These are the lyrics I found online that most closely matched the ones I heard growing up. I may play around with some other ones in the future :D