Historic Norwich churches that have long been out-of-bounds to the public are to open to visitors for the first time in years, thanks to a new scheme.