I've dived WCVI in early July, and already then the viz isn't good, less than 4' when I was out. In August I would think that it wouldn't be much better, as the water would be warmer. You won't be at the surface watching the fishies 20' below you!
Best viz, as I'm sure you know, is in winter.