I tried building the sand carrying system myself but it was too much work getting to the right measurements of all the pipes so I ordered a ready made kit from Amazon. It helped a lot. You would still need to purchase a fountain pump separately to attach to the kit. Other than that, just use some lava rocks to create the hill + use a pond sealer to fill in the gaps between rocks.
V AquaVista Aquatics Sutherland Scapable SandFall Kit https://www.amazon.com/dp/B08XZPWLFS/ref=cm_sw_r_cp_apan_glt_fabc_B6GXXPFG666460W3BHYE?_encoding=UTF8&psc=1
CWKJ Fountain Pump, 400GPH Submersible Water Pump, Durable 25W Outdoor Fountain Water Pump with 6.5ft Power Cord, 3 Nozzles for Aquarium, Pond, Fish Tank, Water Pump Hydroponics, Backyard Fountain https://www.amazon.com/dp/B07FVPLD99/ref=cm_sw_r_cp_apan_glt_fabc_783N7YGXMJ48A9VVZ4YH?_encoding=UTF8&psc=1
TotalPond Waterfall Foam Sealant, 12 oz. https://www.amazon.com/dp/B004DL0XJU/ref=cm_sw_r_cp_apan_glt_fabc_E0C7VYD8HJSYB45Y1EA9
https://www.petco.com/shop/en/petcostore/product/imagitarium-white-aquarium-sand