There are a number of factors that drive acqua alta - mainly wind direction, air pressure, rain and, of course, tides. Of those, the only predictable one are tides and the maximum tides occur with a new or full moon so if one wants to increase the probability of seeing acqua alta, it would be good to be there at those times of the month.