This water simulation is incredibly impressive. IO9 gives a brief overview of the technique.