County council to impose new local government tier despite majority opposition to devolution deal