Barnsley MBC chief Sarah Norman is one of several local government figures recognised in the 2026 new year honours list.