A story I heard about the Scottish tune "Meeting of the Waters" is that the title commemorates a flood when two rivers in north-east Scotland (one of them was the Findhorn, I forget the other) merged into one at a point where they had always been separate.

There's no relationship I know of between the Irish and Scottish tunes.