Exploring Sustainable Water Management Solutions for Farmer Communities in the Mediterranean Region