i got same problem,i started this thrash can grow outdoors ,lost first 2 plants in it,third kicked off and running then bam,so changed the water,which was act of congress in a tressil,so changed out water,walked off came back later in evening and the damn leaves were turning yellow,so ph was 8.5 ppm was 1700,wow i said,so dumped out new mix and made another batch in the 33 gal can,came out on the hour all night,just did what it wanted and never went under 8.5,so at midnight i ran down to the local water machine filled 6 5gal bottles with ro water,came back dumped the stuff and mixed all my nutes at 5.8 ppm 1000 and said screw it if this doesnt work,came back out next morning ph was 5.8 ppm 1000,what i said,so checked it all day,on the hour,temp sored to 104 that day and it had stabilized and plant went green again,lost only 2 leaves on the whole plant,@Aqua Man knows his shit and he is my mentor for the water and saved the day,that watermelon plant is now climbing the tressil so fast it has about covered the kitchen window hahaha.
so that said i feel you on bottle water,now i know im lucky,the ac is in the attic and condensation pipe runs down to the basement thru 3/4 in pvc i collect it and feed my plants that they love it,my water source and aqufer is lime base and the plant really let you know that,so if you wont to grow weed you got to getrdone bro it that simple,in mining country i wouldnt even collect rain water if you dig,here is another thought for you ,boil a barrel of the water and cover it with a lid,that boil most unwanted shit out,your well ,my well suck all there is to it,great for our bodies but not our plants,suck it up and roll if you dig.
another method is as old as the world,gravel sand charcoal,put all in a barrel and filter the water works for old school and extreme work,but shol enough gets the job done,you know me never spend money unless you cant fix it,fix it bromatter chip lmao