I want the fountain totally rebuilt, without its rear end to the Tenderloin, and not spraying cold water
Transform it into a redwood grove (see above). A water feature is rejuvenating if not grey and hard. Rather tiled with locally made ceramics and softened so you get a "nature taking back the City" effect.
Make it round with no back side.
I agreed on another post that it needed some transformation, more green, it is ugly now and I avoid it so as not to get wet when I am walking that way. Round is a good idea.