Two siblings have relaunched a historic hotel in a Scottish city. The move by the brother and sister founders follows a £6 million refurbishment.