Where "very large" is still a lot smaller than the water requirements for hydro generation.

Large enough to replace all that water requirements, without making the lake levels so high that it impacts generation. Which is to say your lake at the bottom needs to have a large surface area when full - much larger than the lake at the top.