A Portsmouth church has celebrated its reopening after a ceiling collapse left it closed for two years.