Nope, the water will always be irradiated as long as you're still playing. This is a huge problem with allowing continued gameplay after the main quest -- everything you've done during your playthrough has little effect whatsoever and you'll never be able to see the consequences of your actions.
Thankfully, New Vegas is fixing this.