The use of saline water resources in agriculture is becoming a common practice in semi-arid and arid regions such as the Mediterranean. In the SmaCuMed project, the desalination of brackish groundwater (TDS = 2.8 g/L) for the irrigation of Argan trees in Essaouira, Morocco, to 2 g/L and 1 g/L (33% and 66% salt removal, respectively) using low-pressure reverse osmosis (LPRO) (p < 6 bar) and membrane capacitive deionization (MCDI) was tested at pilot scale. MCDI showed 40–70% lower specific energy consumption (SEC) and 10–20% higher water recovery; however, the throughput of LPRO (2.9 m³/h) was up to 1.5 times higher than that of MCDI. In addition, both technologies were successfully powered by PV solar energy with total water costs ranging from EUR 0.82 to EUR 1.34 per m³. In addition, the water quality in terms of sodium adsorption ratio was slightly higher with LPRO resulting in higher concentrations of Ca²⁺ and Mg²⁺, due to blending with feed water. In order to evaluate both technologies, additional criteria such as investment and specific water costs, operability and brine disposal have to be considered.