I gotta agree with Dirtyboy on this one. If you are concerned with pesticide residue then you potentially have a serious problem with your water source. But, if you can simply dig a hole as you suggested and it fills with water then you have your water source. Your plants roots do not require any sort of "filter." Don't make it any harder than it has to be. This is one tough weed. Sometimes less is more.