I was in Campbeltown briefly the other day - lovely little place to take a boat into.
The joke of the song, of course, is that the lock is a sea loch so any attampt to drink it dry.....
And, as one of the crew remarked, (somewhat less politely) it really is a long way from anywhere at all!
Steve