Literally, “water man” is correct. But I would translate it a bit more loosely as “water bearer”.
Most, if not all, names of zodiac signs in Dutchare are literal translations from Latin. But while most people understand that Leo means Lion, how many know Cancer is Latin for crab?