A well-known former Sheffield Council politician has died, aged 96.