First time fountain builder

[Ccla]

Hey yall. I'm building a garden pond / fountain.
I'm using a 5 foot replica sugar kettle as the base, and a 2 foot replica kettle as the top. I'm trying to figure out what GPh pump I need.

This is what it will look like

But I'd like the water to flow more like this one

The top kettle has a circumference of 87 inches.
Probably a 3 foot rise of water?

 

[GBBUDD]

If I had to guess 500 gph

 

[j.w]

@Ccla

 

[Lisak1]

I don't know how helpful this will be, but we are installing one of these this weekend. It comes with a 1500 GPH pump and it was recommended that we replace that with a 2000 GPH pump. We're also increasing the diameter of the plumbing - but don't ask me from what to what! I think the plan is to expand to 1.5 inch - but don't quote me on that. I'm just in charge of the pretty parts!