Plans to transform a former church, into nine one-bedroom homes have been approved by Barnsley Metropolitan Borough Council.