I'm using this pump. It's pretty nice.
https://www.amazon.com/gp/product/B076TGWYDK
Self priming, built in pressure switch shutoff, functions closer to a centrifugal and not a true PD pump. Flow backs down as you throttle it. Which is fine for this application. Can generate a smaller warmer stream which might be nice for the waterfall.
Can you find this brand locally? https://www.amazon.com/SEAFLO-Industrial-Water-Pressure-Outlet/dp/B076TGWYDK/ref=mp_s_a_1_3?dchild=1&keywords=seaflo+120v+water+pump&qid=1597121187&sprefix=seaflo+12
The ones you picked look a little different. I think my pick is what you need. I've used them in several similar applications.
I'm using this one: https://www.amazon.com/SEAFLO-Industrial-Water-Pressure-Outlet/dp/B076TGWYDK
I also bought the bulkhead fittings, inline filter, and brass adapters listed at https://www.stocktankpool.net/propane-stock-tank-hot-tub , but I got a Gasland heater and I just cut apart a garden hose instead of using the black tubing.
​
What about this product? https://www.amazon.com/SEAFLO-Industrial-Water-Pressure-Outlet/dp/B076TGWYDK/ref=sr_1_5?dchild=1&keywords=Water+Booster+Pump&qid=1629953447&sr=8-5
​
I definitely do not want to have to get an expansion pump!
If all you need is 300gph (which is about 5gpm), just get a sprayer pump. They have an integrated pressure switch that will activate the pump when the pressure drops, like when someone sprays water out of the hose. Here's an example https://www.amazon.com/SEAFLO-Industrial-Water-Pressure-Outlet/dp/B076TGWYDK/.
You can get ones that run off 12v or 120v, higher GPM or lower, whatever you need. Then just rig in a power cut off to the float switch that will cut power to the pump when the water drops below a certain level.
I used a seaflo pump. SEAFLO 33-Series Industrial Water Pressure Pump w/Power Plug for Wall Outlet - 115VAC, 3.3 GPM, 45 PSI https://www.amazon.com/dp/B076TGWYDK/ref=cm_sw_r_cp_api_glt_fabc_QY1896431TVAPX9VV4BS?_encoding=UTF8&psc=1
Also added a small inline filter: Remes Filter Attachment Garden Hose Pressure Washer Pump Inlet Water Metal Outdoor Gardening, Sediment Filter 3/4 40 mesh https://www.amazon.com/dp/B071489NG8/ref=cm_sw_r_cp_api_glt_fabc_WRY3D7ENQQQT8WAH4ZM5?_encoding=UTF8&psc=1