The City of Cape Town council has agreed to reduce executive mayor Patricia de Lille's role to ceremonial.