It's not Tarwathy, it's Tarwathie and it's in the Aberdeen / Peterhead / Fraserborough area of bonne Scotland. The person in whose persona the song was written was probably a fisherman - if the song was writrten today he'd be a roustabout or tool-pusher.