Historic Cameron House on the banks of Loch Lomond has played host to heads of state and celebrities alike – and it's also perfect destination for a Scotland staycation, as we discovered