You can make custom intake and output pipes from pvc pipe. You can always use krylon fusion black spray paint on them to hide them. It is just a matter of being creative.

As far as aquatic plants. The only thing that will grow in there is floaters. Duckweed, frogbit, pennywort and the like.