New council Chief Executive to be appointed