A luxury Scottish hotel has unveiled its "spectacular" new pavilion following a £750,000 transformation.