You want the mist to be as fine as possible. On my subaru, I had a water spray set up that used very fine nozzles. The way it was set up, a very fine mist was sprayed in the the bonnet scope in front of the intercooler. The water would vapourise as soon as it touched the coooler or even before, therefore cooling the air.
I have seen a few people do tests on the track. Someone found that garden nozzles which used about 1L/min actually cooled the intercooler much less than misting nozzles which used one twentieth of the water.
When I set mine up, I used three brassnozzles designed for evaporative cooling which I imported from the US. The nozzles are made specifically for cooling sports stadiums and the like.
If anyone is interested, I still have the whole kit inlcuding nozzles, adjustable hobbs pressure switch, relays, switch and a custom made electronic controller which holds the pump on for 5 seconds after boost drops (keeps the pump going between gears). I'm willing to sell this kit as I no longer need it.