I tested six filtered water bottles by filtering and drinking water, checking for leaks, weighing them and more. After all my tests, there’s only one you should buy.

For a glimpse into America’s complicated relationship with drinking water—bottled and tap—consider the town of Hudson, Mass., 40 miles west of Boston. This spring, residents grappled with fallout from ...