New council CEO coming from Perth to take up city's top job