Former England manager Gareth Southgate and a director at North Yorkshire Council have been knighted in the New Year Honours.