“Massive” changes to waste management at Caerphilly County Borough Council will “take time” to implement, the service’s cabinet member has said.