Shropshire Council's leader has announced the shock decision to step down as a councillor at May's elections.