A picturesque hotel on the edge of a loch has been crowned Scotland’s 'Hotel of the Year'.