To get the correct look for water at higher resolutions you need to play with the substeps and iteration parameters too, as well as viscosity and cohesion. To get thinner looking fluids it is generally a good idea to have fewer iterations in the simulation.
Marsel Khadiyev (Software Developer, EPHERE Inc.)