Also a note I think your rain is too dramatic. When you photograph rain at night you really shouldn't see the drops, unless it is in front of a light
True, i completely forgot about it, thanks for tip ;)
It would definitely be possible in Corona, it just might need a few different approaches to get it looking right.
The texture on the wet asphalt should be pretty easy - a combination of a droplet map (something like https://xoio-air.de/2012/water-droplets/), mixed with some noise/fractal maps to give you the randomisation.
A trickier element would be the splashes of water jumping back off the ground - but you could achieve that by scattering a few random blobs with CScatter or ForestPackPro.
When I have a spare 30 minutes I'll try and knock something up!
Thanks for link to texture, your idea was really good. I made test render. I used two planes: one with mix asphalt, and second 0,01cm higher with water material. The water mtl has addictional opacity and bump map, and plane has addictionaly displacement mod with drops on water tex. I'm happy with effect, but i think the rings should be smaller.
Bubbles and splashes scattered with FP lite, rain in PS.

how do you think what else to improve in terms of rain and its effects ?
I know, sky should be darker ;)