Wasn't this the plot in an NCIS-LA episode a while back? Except that the bad guys were actually physically inserting their noxious substance.
A few years ago, my local water authority did the job themselves without any outside help. In the North West we were pre-boiling water for weeks until the system was cleared.