Emporia, Kansas is known for having clean, great-tasting water as it won the Best Tap Water prize at the 23rd annual Berkeley Springs International Water Tasting. Missouri: Missouri has some of the best drinking water not just in the U.S., but in the world.