<p>Southern India Cauvery Delta experiences severe water shortage that is enhanced by climatic variability, changing agricultural requirements, and socio-political disputes, which makes the traditional water management strategies insufficient. As one of the solutions, we suggest a new multi-criteria decision-making (MCDM) model that uses Yager Power operators and complex q-rung picture fuzzy sets. This model includes two highly flexible aggregation operators that are new and include the complex q-rung picture fuzzy Yager power weighted average (Cq-RPFYPWA) and geometric (Cq-RPFYPWG). Cauvery Delta Case Study examined the strategies such as drip irrigation, rainwater collection, infrastructural development, and agriculture that is sustainable. Findings indicate that drip irrigation has the highest ranking, which is then succeeded by sustainable agriculture, rainwater harvesting, and infrastructural upgrades. The sensitivity analysis assures us of the consistency and usefulness of our strategy in dealing with complex uncertainties. The study will provide a powerful instrument in prioritising the strategies of water resource management to enhance the precision and accuracy of decision-making in the intricate settings.</p>