Isothermal quantum hydrodynamics: derivation, asymptotic analysis, and simulation