This was discussed a few years ago, but don't know the thread title. However, I have a habit of making notes about songs I like, and this is what I put together from the contributions made at the time :-

Sweet Carnloch (or Carnlough) Bay is an Irish version, and there are several others, including one found in Canada. The Irish version was publicised by Colm O'Lochlainn in his Irish street ballads (1939), O'Lochlainn having had it from Cathal O'Byrne in 1913. Authorship has been attributed to Richard "The Poet" Mckay (pronounced McKee), who was born in Armagh in 1800 and died in Blairgowrie in 1897. There is an alternative attribution to a D. Young of Dysart in Fife, who is said to have composed the song in 1825 for David "Flutorum" Hatton, an eccentric innkeeper. The tune is Bonnie (or Adieu ) Dundee.