Hanauma Bay water is great. You have to go a couple miles to find a sewage outlet, near sandy beach.
The place with nasty water is the Ala Wai Canal
I hear Alimentary Canal is pretty bad also......