Plans have been approved to downsize part of a historic church building which is now “too large for their needs” and convert part of it into homes.