This one?

LONELY SCAPA FLOW (A. Windwick).

These words come from the same Jim McLeod album as Kirkwall Bay. The song has been re-recorded recently by the Orcadian band Three Peace Sweet and slightly different words are listed in the CD, Lightning Touches (1999). This new version has a different feel from the McCleod version. Allie Windwick wrote the words and Angus Findlater made the first recording in 1965.

Do you recall my dear how once, you walked with me,
Across the warm brown hills, towards the shining sea?
And how we lingered long upon the shore to see
Beloved ships come sailing up the flow.

Chorus:
But that was yesterday, and now they come no more,
Among the small green isles, where oft they lay of yore,
And so we linger sadly, by an empty shore,
And shed a tear for lonely Scapa Flow.

We saw them anchored proudly as the sun went down,
And heard a lonesome bugle from the old Renown.
And o'er the gleaming ocean, like a brand new town,
10,000 port lights winked on Scapa Flow

Chorus.

And for a while we met not on that darkened shore,
No winking port lights then, to glint the wave tops o'er.
And there were those who came who will return no more.
Who are asleep in lonely Scapa flow.

Chorus.

From: http://www.stephen1966.freeserve.co.uk/songs.html#Lonely%20Scapa%20Flow