With such a pollution there is a modification/destruction of the food chain of many species of insects, birds, fishes and a possible contamination of the drinking water for human and other warm blooded animals
There are many types of pesticides in use. Each pesticide has different effect. So, for your question, it depends on the type of pesticide which is polluting the water.
Pesticides are substances used to repel, kill, or control certain forms of plant or animal life that are considered to be pests. Pesticides contain Organophosphates & Carbamates or Organochlorine compounds. Both surface and underground water can be polluted with pesticides by direct washing from the farms due rainwater or surface runoff, or by leaching through soils.
The immediate or acute health effects include irritation of the nose, throat, and skin causing burning, stinging and itching as well as rashes and blisters. Others are nausea, dizziness and diarrhea.
The chronic health effects of pesticides to both adult adult and children include; brain and endocrine disruption, leukemia, lymphoma and cancers of the brain, breasts, prostate, testis and ovaries.
Pesticides alter both physical and chemical properties of water such as oxygen carrying capacity,turbidity and pH of water and effects growth, reproduction, movement, malfunction of organ such as eye and kidney, disturb the normal distribution and causes change in behavior of aquatic organisms such invertebrate as well as vertebrates such as fishes, amphibians, reptiles, birds and mammals.you can also see the following links:
The biggest threats posed by pesticides is bio-accumulation and bio-magnification in the system as well as the aquatic organisms. This not only causes heavy biodiversity losses but have an adverse effect on the endocrine system of the aquatic organisms especially fish. Being potential endocrine disruptors pesticide cause delay gondal maturity which in-turn have a great effect on the breeding and recruitment pattern. Pesticides concentrations above permissible level can cause oxidative damage to fish tissues, histopathological alterations and mutagenic changes. There is a long list. If you are still more interested i can forward you my research on pesticides.