A “kind and thoughtful” former council leader who steered an authority through a “very bumpy period” has died aged 88.