Refurbished Aberdeen sports centre officially opened