I drink 3+ liters of water daily and it's spring water or nothing. I'll go thristy or find a soda before I drink bottled tap/tap water offerings (aquafina/dasani) and yes, I can and have detected the difference between spring and other water types.
The best water I've ever had was a bottle of glacier water I bought when I was in Canada many years ago. I don't recall the name, but I held onto that bottle for a while hoping to go back. For premium waters, Fiji is one of the better ones; I consider Voss grossly overpriced and Panna basic.
I don't have a single brand preference for my spring water, although I buy most of my cases from Costco so it usually ends up being whatever brand they're offering (I often buy a case when I'm on business travel too as it's less expensive than buying water daily if I'm gone for 3+ days and a warehouse is nearby -- each region carries different brands). The costco and wegman's brands are okay, but I prefer a Deer Park, Poland Spring or Arrowhead level usually.