Yes, they can be in your tap water. You should absolutely be concerned about both fracking fluid in certain areas and prescription drugs in your tap-water in all major cities. Here is a video on drugs in your water.
Fracking fluids are toxic and can contaminate your wells and tap-water. But not all fracking sites contaminate the ground water. Fracking occurs mostly at depths far below ground water. But there have been numerous cases of methane seeping into wells and tap-water. It is a complex issue of trade-off between energy supplies and clean and safe water. For more details, see fracking trade-offs recently faced by Governor Cuomo of NY State.
The US Environmental Protection Agency is soon expected to issue regulations on fracking.
Prescription drugs and household personal care products fall into a new category of toxins called Emerging Contaminants, and pose a problem in major cities where sewer water from toilets and sinks are recycled by water utilities for drinking. Despite best efforts by water utilities, trace amounts of antibiotics, hormones, pain killers, and blood-pressure medications are present in drinking water supplies. They are of serious concern for homes with young children or pregnant women. Here again life-saving medications and safe drinking water supplies are in conflict. For more information, please see these two articles: Prescription drugs article 1 and article 2.
Certain contaminants such as Percholate can mimic natural hormones and disrupt the endocrine system such as the thyroid. This type of contaminants are called Endocrine Disruptors. EPA has recently decided to regulate these contaminant levels.