The search for a new chief executive of Caerphilly County Borough Council has begun.