The only five-star hotel in Scotland’s granite city is to undergo a multi-million upgrade.