A Portsmouth church is set to celebrate its reopening after its ceiling collapsed - forcing it to close for two years.