Museum named best building in Scotland after major refurbishment