Auto-cleaning room (CIP for the ground?)
Cleaning with water comes down to two things - pressure and volume.  Those are related, so to increase one, you have to decrease the other without something like a pressure pump to artificially increase the pressure of the system.

So, will it work?  Absolutely, but the water volume and spray pressure you get will be limited.  What I would do is buy some PVC pipe, and start drilling.  You can get 20' of pipe very cheaply, and it is easy to cut and drill.  Pick a small hole size, and space your holes every 2 feet.  Test it and see what happens.  If you have plenty of pressure, but want more water, drill more holes or re-drill the holes to the next largest size.

If you want to evenly coat the floor and don't really need pressure, then some sprinkler nozzles could be a very effective solution.  Once you have a hole or nozzle pattern that seems to work, you can replace the PVC with metal pipe if it needs to be more durable, but honestly, SCH40 PVC pipe is pretty strong.

What you want is not a "home improvement" idea.  It's more like adapting a commercial solution to the home, so you're going to have to build your own.  The trick is using materials that are cheap and easy to work with for prototyping along the way.