Well, i don't think spray heads would be necessary and definitely not daily waterings.
Esp if you used a hardy herb like a prostrate thyme, say, Woolly thyme (Thymus pseudolanuginosus) or similar.
As an experiment, why not put a small section of 4 or 6 or so pavers onto the soil, maybe cut out a bit of lawn and do it in full sun, give it a good wet, lay the pavers down and see how long it takes for the moisture to dry up under the pavers. I'll bet it's still moist after a week. Probably longer even with decent drainage.
One thing though, make sure the drainage is good under the pavers. If it holds too much moisture you'll get problems.