By bad odor....can you be more specific?
We have the mother load of water problems in this region. First, the well water smells like rotten eggs (sulfur bacteria) when it's heated and sometimes even when it's cold. Second, it is loaded with rust so the water is often yellow orange and turns everything it touches orange.
1. We use a charcoal filter at the water spout and another where the water enters the camper. (Not a cheapy campco).
2. We use an iron filter which clears out the iron and other impurities...they generally cost about $1000.00...but no way around it if you have iron...nothing else filters it. Now we can safely get our things wet. As newbies here last year, we didn't know the rust in the water could spoil everything on contact. Thank heavens it didn't get on our camper, but it turned our green shed orange from watering the grass and my car got a nice orange/mother of pearl sheen (Gross). Planned on painting the shed anyway, which we did this year. The car had to be buffed out.
3. Because the area's well water is so bad, there are many "water stores" where you can buy purified water in small or large quantities and that is what we use to drink or cook with. Our triple filtered water is clear and smells fine now, but I still don't trust it. It is safe however to clean things with now and no longer stinks.
Hope this helped with possible problem solving...and above all, you know you're not alone.