Geoff Raw confirmed as council chief executive