A hotel in the heart of Edinburgh has been named the Scottish Hotel of the Year for 2025.