A Southampton pub has reopened with a £250,000 makeover aimed at creating a new hub for sport, entertainment and community events.