here's almost a done pic of everything. Since the tale of these pics the sewer caps have been cut lower and the fountain itself has a different nozzle so that there's very little to no turbulence. The water lily is doing really well, I'll be taking more pics next week when we go do maintenance. The only thing I'm bummed about is unable to hide the pump cord, we chose to not drill it just bc I was not confident in keeping it from leaking. Thanks to everyone for y'all s help
Insanity: doing the same thing over and over again and expecting different results.