I think that as long as you have an option for drinkable, cool water available to the guests, they'll be happy.
For me, there is nothing worse than wanting a cold glass of water and not being able to find it or having to bother an innkeeper for some ice, especially on a hot summer day or after coming back from a walk around town or hike on a country road.
We are in a HOT climate and it can get miserable here. The cold water in our tap may not be that cold in the warm weather months. Our guests frequently were out and about for major events nearby and grabbing a cold bottle of water to take with them was a big perk. We encouraged recycling of the empties but I'm not their mother. I tried to figure out how I could work it with "green" refillable water bottles or something like that and it was just not a good trade-off for me in my time and the expense. I was only one person...
We all have to do what works best for us!