Just got my lake finished. Its 1.5 acre. want to put a lake fountain in the middle. I know nothing about them. was wondering what is the best thing to do.

Thought about making my own. Running pvc on the bottom of my lake and 90 up above water level and putting a cap on it with holes drilled in it. it is about 15ft deep there. Then put a electric pump from lowes on the dock and run the pipe to it.
Dont know what size pvc or pump to buy. Any info will help

will this work. Sorry for such a long post and alot of questions.