Departure of senior North Yorkshire Council officer announced