Protected sites are among the areas hit by poor water quality, a report from a partnership of environmental charities has claimed.