Water is a fundamental and crucial natural resource for human survival. However, the global demand for water is increasing, leading to a subsequent decrease in water availability. This study addresses the critical need for improved water resource forecasting models amidst global water scarcity concerns exacerbated by climate change. This study uses the best weather and water resource forecasting model for sustainable development. Employing a Recurrent Neural Network–Long Short-Term Memory (RNN-LSTM) approach, the research enhances drought prediction capabilities by integrating secondary data of the rainfall, temperature, and ground and surface water supplies. The primary objective is to forecast water resources under changing climatic conditions, facilitating the development of early warning systems for vulnerable regions. The results from the LSTM model show an increased trend in temperature and rainfall patterns. However, a relatively unstable decrease in rainfall is observed. The best statistical analysis result was observed with the LSTM model; the model’s accuracy was 99%, showing that it was quite good at presenting the obtained precipitation, temperature, and water data. Meanwhile, the value of the root mean squared error (RMSE) was about 13, 15, and 20, respectively. Therefore, the study’s results highlight that the LSTM model was the most suitable among the artificial neural networks for forecasting the weather, rainfall, and water resources. This study will help weather forecasting, agriculture, and meteorological departments be effective for water resource forecasting.