The song is in Shay My Pious Friends and Drunken Companions, 1927, from the singing of James Harris. There is a site for this book which has a link for a big pdf, but the link is dead.
There's info on the song, with Jimmy Rogers and Harry Belafonte versions on the bluegrassmessengers site: Water Boy
Mick