I have seen mods where people added fountains and thought they looked great. I was jealous so I wanted one too. However, my delima was I didn't want to be running the sand filter pump while kids playing in pool. This may change when I add an thru wall skimmer this weekend. Anyway, back to the fountain. . . My method was simply I bought a submersible pump at harbor freight . Caught it on sale and with 2 year replacement it wasn't much money at all. One stick of 3/4" PVC, a T, 90, 2 end caps and a threaded fitting . .that was the supplies. Cut 2, 2 foot sections for sprayer heads . .drilled around 8, 1/8th holes in each and put them unglued on the T fitting. Cut about a 4 inch piece to 90 from top and placed it on 90 degree fitting. Glued the threaded fitting to the remainder of PVC and threaded it on to outlet on pump. Leaving the T and the elbow unglued let me set in pool and test height . . Turned out to be perfect so I glued the 90. I left the shower wands running into the T unglued so I could rotate for the spay angle. Turned on pump and and WHAM . Wall of spraying water. Very cool . . Took maybe 15 minutes to do. The pump has a 10 foot cord so easily routed out the way. The pump is in the pool along the wall on the floor but it really isn't in the way at all. The kiddo LOVES it. Just an idea for people who don't want to hack the plumbing but want a fountain that is awesome and removable. I do have a zip tie around the fountain shaft to the rail of the pool just so someone wont mess with it. But easy to remove. Bonus, I can drain the pool with it, I am working n making a self contained vacumn with another pump. Can't go wrong having one. Replaced free if it burns up in two years or less.
Food for thought.