The quick answer is yes, the water should reach your destination, and the pressure you get will depends in large part on the diameter of the pipe/hose/tube you run, and the 'fullness' of the upper tank of water.
Assuming an ideal fluid, you'd use Bernoulli's principle to calculate your downstream pressure:
P1 + 1/2ρ[(v1)^2] + ρgh1 = P2 + 1/2ρ[(v2)^2] + ρgh2
Learn more here:
https://www.khanacademy.org/science/physics/fluids/fluid-dynamics/a/what-is-bernoullis-equation
P1 and P2 will be the same, because you've got atmospheric pressure at both ends of this thing, and since we're recklessly simplifying stuff, we should just call the initial velocity (v1) zero as well, because your reservoir is large enough.
That means your pressure in this system is coming from h1, your hydraulic head. More height difference between the sprayer and the top of the water in the big tank = better pressure.
The hose size piece of this puzzle has to do with Poiseuille's Law (pronounced: P-wah-z-eh?). Details spared here; bigger diameter is better, longer run is worse. [don't go there with the joke]
That's the rough fluid dynamics of the situation, but as always, prototype it out at home before you build it on site
