Plans to convert a former church in Bishop Auckland into a house have been approved by the council.