Differences: Different installation, different challenges.
Water:
PRO: Disperses more heat, no RAM or mosfet interference, looks cooler (no pun intended, opinion)
CON: More failure points, harder installation
Air:
PRO: Less failure points, easier to install
CON: Disperses less heat (generally), RAM and mosfet clearance issues (possibly, all depends on what you get).