It actually specified that "Food" cannot be created out of thin air, it doesn't specify water. Additionally, the "air" itself contains quite a bit of water. Put a cold glass down during hot weather and you can "Aguamenti" some water for yourself.
As far as what it actually does; it conjures up water from the tip of the wand in varying amounts (seemingly depending on the user's intentions and concentration).