I always save the Council in the end, either on my Renegade or Paragon playthroughs.
Simply because, the Council is crucial towards the greater picture of a united galaxy in preparation to face the Reapers. The Council dying is essentially the greatest selfish act you can perform in that scenario, elevating humanity above everyone and everything else (mostly due to petty vengeance) in order to complete your objective and leaving the galaxy in a state of civil unrest. Which no less, is a pretty damning thing when the Reaper invasion actually does begin, and the Humans and Turians are still taking shots at each other at the expense of the greater picture.