You could edit the MTL file exported from Art of Illusion and add a d line for the material of the water (value between 0 for fully transparent and 1 for fully opaque). See also MTL specifications and some existing models like this wall lamp.