Controversial plans to change the type of affordable apartments included in a planned block of flats have been approved by Caerphilly County Borough Council.