The maps I know of with waterfall effects are Raiders, Dark Forrest and wop_bath. I was going to decompile them to see how they were built. What I really don't know how to do is make the water splash and ripple at the bottom of the waterfall.
LCDLC Mapmaking Dept.
Maps finished: Hellhouse, Sorry, Worrior 1-20
Maps modded: CubeOrigin
Maps in release candidate: Blockforts, Cannons 1, Hotzone, Icecastle
Maps in beta: Arctica, Cannons 2, Cerulean-River, Igloo, Skygarden, Spacestation
Maps in alpha: Merlin, Totem