Today as in Ancient Rome the aqueduct terminates at fountains. It does not connect to the standard modern municipal plumbing. Whether that counts as being operated for "tourist purposes" is a matter of definition.

https://en.wikipedia.org/wiki/Acqua_Vergine