Sitting in a loop of the River Forth within sight of Stirling Castle, this quiet place has witnessed some key moments in Scotland’s history