Here's one piece of advice - your waterfall should be solid and secure WITHOUT foam. Foam serves one purpose - filling gaps between and behind rocks to keep water flowing over and not between and behind. If you have to use foam - or anything for that matter - to hold waterfall rocks in place you're not going to be happy with the results. You should be able to run your waterfall without foaming anything and not actually lose any water - whatever goes behind or under the rocks should still end up back in the pond. Visually you will "lose" it, in that you won't see it flowing as much, but it's still gotta flow into the pond, if that makes sense.
In short - foam won't stop leaks.