Council chief executive Geoff Raw to leave the council