Supposedly it's just plain water with a little percentage of the spice Melange. The most popular beverage among the Fremen!
UPDATE: I 've redone Paul's face, hair and collar a bit. Hope it'll look better.
So you're the only one who remembers the movie, eh?