North Yorkshire Council chief executive announces departure