The following package of technology allows you to harvest water day and night at a RH of about 45%.
A few PV panels some Peltier coolers, a small low flow ventilator, a small water pump and some flexible tubing (PVC or the like) with a diameter of about 20 cm. shape the tubing like a U. Connect a small tube watertight to the bottom of the U tube. In the U tube you mount the Peltier coolers before the ventilator at the end and on top of a small tubing so that condensed water can fall in the small tube (maybe use a small funnel as a water collector)..Isolate the whole U tube setup, to make the cooling losses as low as possible. Dig it into the soil so that the lowest part is about 1 meter below top soil level. Connect all the electrical units, e.g., the Peltier element(s), ventiltaor and water pump with the electricity supply from the PV panel(s), prefarably all units at the same operating voltage (annihilates transformation loss). And let the beast go!.
If all goes well you will generate a steady water flow from your setup. Energy source is the sun! Source of water, the atmosphere with 45 % RH, the water condensor is the Peltier cooling element. The hotter the atmosphere the more water you will generate at 45% RH.
By the way, thermoelectric cooling uses the Peltier effect to create a heat flux between the junction of two different types of materials. A Peltier cooler, or thermoelectric heat pump is a solid-state active heat pump which transfers heat from one side of the device to the other, with consumption of electrical energy, depending on the direction of the current. Such an instrument is also called a Peltier device, Peltier heat pump, solid state refrigerator, or thermoelectric cooler (TEC). They can be used either for heating or for cooling (refrigeration) In practice the main application is cooling. This technology is far less commonly applied to refrigeration than vapor-compression refrigeration is. The main advantages of a Peltier cooler (compared to a vapor-compression refrigerator) are its lack of moving parts or circulating liquid, near-infinite life and invulnerability to potential leaks, its small size and flexible shape (form factor). Many researchers and companies are trying to develop Peltier coolers that are both cheap and more efficient. Check out the market.
The Incas in the Andes five centuries ago have recovered the dew water through stone slabs placed upright. I do not know if the temperature during the night in the area you treat will be enough, but as I said, was a method of water recovery. Besides all cheap.