The Mudgeeraba drinking water treatment plant, in Southeast Queensland, Australia, can withdraw raw water from two different reservoirs: the smaller Little Nerang dam (LND) by gravity, and the larger Advancetown Lake, through the use of pumps. Selecting the optimal intake is based on water quality and operators' experience; however, there is potential to optimise this process. In this study, a comprehensive hybrid (data-driven, chemical, and mathematical) intake optimisation model was developed, which firstly predicts the chemicals dosages, and then the total (chemicals and pumping) costs based on the water quality at different depths of the two reservoirs, thus identifying the cheapest option. A second data-driven, probabilistic model then forecasts the volume of the smaller LND 6 weeks ahead in order to minimise the depletion and spill risks. This is important in case the first model identifies this reservoir as the optimal intake solution, but this could lead in the long term to depletion and full reliance on the electricity-dependent Advancetown Lake. Both models were validated and proved to be accurate, and with the potential for substantial monetary savings for the water utility.