The water goes nowhere - the yeast consumes the sugar giving off CO2 as a by product. When all the sugar is gone the CO2 stops being produced. However there is not enough CO2 being produced near the end of the process for us to use in the planted tank.
Have a look at some of the stickys and threads at the top of the planted section for more help.