I live in the SF Bay area now and use no filter and the water is fine.
My parents have a well and when they were concerned with their water they subscribed to a water delivery service that dropped off reusable 5 gallon bottles every couple weeks that is still orders of magnitude better than individual bottles. (Each 5 gallon bottle replaces 40 16 oz bottles and is refilled)
One of their neighbors installed a big (200 gallon?) water tank and hired a service to refill it. My parents ultimately ended up installing a filtering system when it became clear that the well wasn't going to get better. Which would have been cheaper that the water deliveries long term, but less than 2 years later the city ended up bringing municipal water to their neighborhood.
There are lots of more environmentally friendly alternatives to single serve bottles.