1. You seem to be assuming that a perfectly tensionless water would make for a superior cleaner, but there’s no reason to assume that would be true. Lowering surface tension is not the sole reason that soap is a good cleaner; it’s not even the biggest reason.
2. I have no idea if water can be made perfectly tensionless, but that’s what dishwasher rinse-aids are for: to make the water molecules stick to things (including each other) less, so they evaporate more quickly & easily. If You Want Drier Dishes, Use Dishwasher Rinse Aid

.
Edit to add: I suppose that definitionally no liquid is without surface tension.

A liquid is made up of tiny vibrating particles of matter, such as atoms, held together by intermolecular bonds. Like a gas, a liquid is able to flow and take the shape of a container. Unlike a gas, a liquid maintains a fairly constant density and does not disperse to fill every space of a container.