While Scapa Flow is well known for its role as one of the world's great naval bases during the two world wars, the Forth and its estuary had an equally extraordinary story to tell.