A senior officer of North Yorkshire Council is "still in shock" after receiving a knighthood in the King's New Year Honours list.