That tube is likely attached to the water heater relief valve. The relief valve discharges when the pressure or temp gets too high in the water heater tank. Although they do sometimes just fail, a drippy relief valve is often a symptom of underlying issues.