A senior councillor has admitted a review of North Yorkshire’s council divisions will see communities ‘split up’ across the county.