Prediction of long-term water quality using machine learning enhanced by Bayesian optimisation