Molecular density functional theory for water with liquid-gas coexistence and correct pressure