I have found lots of leaks in my time. Occasionally by myself, but almost always its at least a two man job.
First thing to try, is something I have luck with in certain conditions. It might work here.
Find yourself the brightest light you can find. You may have to block the windshield off with something opaque like aluminum foil.
Go out at night, unless you have a totally lightproof garage.
Pull as much of the cowling off as you can, set the light up under the dash pointing at the leak.
Let your eyes adjust to darkness, then switch on the light while laying on the hood looking along the edges for a slight reflection.
Water will certainly go places light will not bend around, but you would be surprised how many times you can see a slight glow.
The advantage to this is that its dry. You can move the light around and there is no lingering light. Once you start pouring water, everything gets wet and sometimes you have to let it dry and start over.
If the light does not work, then its time for water.
The key here is moderation and goggles.
One person needs to be under the dash with goggles on and a light.
The goggles are crucial. When the water hits your face, it usually gets into your eyes.
Which squeeze shut just at the second you need to be able to see.
With goggles, you can stay there and take it long enough to see where its coming from.
And the guy doing the pouring needs to do it gradually. Pour, and then wait.
It might take a minute or more for the water to work its way down.
If you pour into the obvious places and nothing happens, move farther afield.
Remember under certain conditions water can move uphill if it builds up somewhere.
But, most of the time if you don't find a leak, go up.
You might pour gallons around the bottom of the windshield with no results, pour an ounce at the top of the windshield gasket and have it all pour out the inside of the dash.
Oh, and don't forget the top part of the firewall under the hood. Water can run down through the hood seam, down the front of the firewall and into a hole.