Viscous attenuation of mean drift in water waves