Plans to demolish a former social services building in Newport and replace it with ten “extremely affordable” homes have been approved by the Isle of Wight Council.