Stephen Foster's "O Comrades, Fill No Glass for Me" is a temperance song of sorts (long before the Temperance movement, however.) Written from personal experience. Great words and the tune has the feel of both a temperance-type hymn and a drinking song--especially if you liberally slur.

I remember a fun, little Temperance song ("A Social Drink"?) which begins "I used to like a social drink (So did I! So did I!)..."