Tetra Whisper Internal Power Filters at PETCO
this is the type of filter commonly used to hide inside for a spillway/waterfall... it is very easy to get to things as opposed to others... the reason i suggested a hob is the same reason i suggest this type... lift the top and your media is right there... no hiding the filter in a cabinet you have to pull it out of before disassembling. you can wrap it with wax paper and spray your foam and crete around it to make a nice groove for it to fit in depending how you do it and provided you take into consideration water still has to get to the bottom.
type of filter usually is determined by your build or your pocket... sometimes by just what you fancy. some even just use fish or waterfall pumps... waterfall pumps are a lot cheaper for what you get usually and they're exactly what you get in the decorative waterfalls you can find at walmart or home depot. for ease of use and so you don't have to design a filter the above filter should do great.
morter would be what you are looking for for cement... it has no rocks in it... some people use habacrete because it is inert, but it is expensive and ordering online recently has proven to be an issue for some people.
another thing you could use is grout for bathroom tiles... you can get it colored or you can purchase the color seperately which can also be used for the mortar.
either way you should leach the chemicals out for a while (a few weeks) before putting anything in there with crete. most report that vinegar helps neutralize the ph of mortar during the leaching process.
to keep the foam together silicone will really help... ge1 or ge2 should be alot cheaper than aquarium sealant (you can also find different colors) just make sure your tube says 100% silicone... toothpicks should really help to keep your structure together while the silicone is drying. another helpful tip... many people use soldering irons and heat guns (carefully) to shape, cut, texture and/or seal their foam.
here is a link that should help:
Lizard care, and fake rock wall landscapes
i also wanted to mention that many people use mod podge for coloring/sealing, but i don't know how well it stands up under constant running water.
if this jumps around a little and don't make any sense please excuse me... chasing kids and running from the wife right now.