Functioning water towers are required by law in NYC buildings over a certain height. They are often enclosed in modern buildings so you don't notice them. They are necessary because of water pressure issues in Manhattan. Without water towers you would have difficulty getting water pressure on upper floors.
Hope this helps!