The top of the tower is off limits, due to dangers inherent in the narrow staircase that leads to the look-out point, so the best bet for a panoramic view of the city is the top floor of one of the taller, more recent hotels.
Even though the most recent hotels are not as high, they still offer a pretty view.