Plans to convert a church which is almost 150 years old and “falling into disrepair” into two homes have been approved.