The hydro-climatic variability and its implication for water mangement using machine learning techniques