Caerphilly County Borough Council’s former director of social services, Dave Street, has taken on the new deputy chief executive role.