Fountain 1: At the firehouse. You only need to drink from this fountain once (even though you revisit the firehouse many times).

Fountain 2: At soon as you enter the Sedgewick Hotel, the soda machine room to your right.

Fountain 3: After the water drains from the hallway (at the Sedgewick) but before you reach the Sargassi Lounge, check the corner of the elevator lobby for the fountain.

Fountain 4: In the laundromat Zeddemore breaks into at Times Square. It'll be by the cursed artifact, pushing bone - in the back room - so to speak.

Fountain 5: After the cut-scene of Hoss and Stanz and the two office workers in the elevator at Times Square, you will be at the architectural office. The fountain is at the corner of the hall.

Fountain 6: Public Library. The hallway leading to the juvenile reading room will have this water fountain.

Fountain 7: After the Egyptian and Mummification exhibits at the Museum, Venkman will spring out to surprise Hoss and Zeddemore in a maintenance hallway. The fountain is there, right next to the Azatoth Head artifact.

Fountain 8: When revisiting the Sedgewick, you need to turn the power back on at the generator room. The fountain is in the generator room.