BP_Waterfall is a sheet mesh with the falling-water material. In front of the sheet there's an optional body foam shell. A bottom foam mesh sits where the water lands, and a particle system adds mist and splashes.
You place it yourself where the river ends, and scale it to the drop.
Drag BP_Waterfall into the level.
Move it to the top of the drop.
Scale it so the sheet reaches the water below.
Width Multiplier makes the sheet wider without changing its height.
Put the bottom of the sheet slightly below the receiving water. The bottom foam now sits on the surface, not above it.
Under 01. Appearance, leave Water Style on DA_WaterStyle_Tropical, the default. It sets Material to MI_Waterfall_Tropical for the sheet and Body Foam Material to MI_WaterfallFoam.
To change one waterfall, pick your own instance in Material. It stays until you pick a different style.
Turn on Enable Body Foam to add the white foam shell in front of the sheet. It's off by default.
For a new look on all your water, make your own Water Style (chapter 10).
Where rocks stick out through the falling water, the sheet should open around them. BP_WaterfallOccluder does that.

An occluder sphere on this rock opens the main demo waterfall around it. The white water on top is a placed NS_RockSplash.
A waterfall takes up to eight spheres. A sphere counts against every waterfall it touches.
Drag BP_WaterfallOccluder into the level. It's in Blueprints/WaterEffects.
Fit its blue sphere to the rock with the sphere's Sphere Radius or the actor's uniform scale. The sphere must overlap the waterfall.
Keep the actor tag Waterfall on it. It's there already.
The sphere doesn't show in Play and has no collision.
Select the waterfall.