Aurands “Fountains and Pools” is a basic reference.
Your state building code is critical. Over a certain water depth (in California it’s 17.9 inches) a fountain becomes a swimming pool with a whole different level of requirements (like fencing).
A water wall water thickness depends on the roughness of the surface and the effect/sound level you want. No hard and fast rules there. For weir flow, I advise 3/8 inch minimum.
For low flow creeks…that’s a question for your local fishery biologist.