If you are taking a holiday in one of the 27 EU states, then the European Environment Agency's Eye on Earth initiative enables you to checkout the water quality of the beaches or inland waterways near to your destination through its Water Watch site.

The site uses Microsoft Virtual Earth to display official water quality data and also gather user feedback on individual beaches and waterways.
Disclosure: Microsoft is a client