North Yorkshire Council chief executive to be paid up to £197,000