Social Democrats councillor announces shock resignation — ‘Demands have grown to an unsustainable level’