It should be fine imo. Weeping Willows and such suck up lots of water I believe. My area has lots of oaks and it’s quite rocky. Like any tree it will need water, but I don’t think your well will suffer at all. Water will seep into the well from all areas. I don’t think one tree will hurt it.