NYC tap water is amazingly delicious, isn't it? The story of where it comes from, and the massive engineering projects that bring it to your tap (such as Water Tunnel #3, currently under construction) are equally amazing, you might start here:

Some restaurants in NYC, of course, try to upsell patrons into buying bottled water ("Will that be Still, or Sparkling?"). And some tourists fall for it.