In this work, an effort has been made to comprehend the applicability of surface water in Brahmani Basin, Odisha for human consumption. Seven samples totalling 14 physicochemical parameters for the 2020–2023 period were examined and compared to the standard criteria advised by WHO methodologies to measure water quality using two indexing methods: Weighted Arithmetic (Wa) Water Quality Index (WQI) and Criteria Importance Through Intercriteria Correlation (Cr) WQI. As a result, Multiple-criteria decision making (MCDM) models, such as Evaluation Based on Distance from Average Solution (EDAS) were implemented to eliminate WQI index discrepancies, and they have been used to pinpoint the best spots along a river stretch where the water quality meets acceptable drinking criteria. The result of the WQI indicates that 57.14% (Wa-WQI & Cr-WQI) of surface water samples had poor drinking water quality. The area under study’s overall WQI, demonstrates that the water is fit for drinking (around 42.86% good water) except few localized pockets in location S-I, II and VII. Farmland, landfills, industrial effluent, residential sewage discharge, pesticides, garbage, habitations, and other potential sources of pollution can all contribute to poor water quality. Putting the above MCDM models into practice, it was clarified that S-I, II and VII was the most polluting area compared to most places. This was evident from the highest Wa-WQI and Cr-WQI values at these locations. The results revealed that this approach brings about noticeable results, which can support water resource planning and sustainable use in the research area.