I've monkeyed with the PVC overflow before and the noise was unbearable for me. If it's not an issue for you, then it's not for others to say it is. Same thing for the ugly factor. However, in the spirit of helping, what this site is for, I would also advise against the PVC overflow due to its unreliability. I understand that many people have had some measure of success with this project, but I think more have been less than thrilled with it.
But in keeping with your desire for a DIY project and keeping cost down, I would suggest that you buy a cheap box style shown above, or make your own. You can then drill the tank and install a Herbie style overflow at the least. You would then have the advantage of a truly silent overflow with a measure of blockage protection. It would cost a bit more than the PVC overflow, but not near as much as buying a prefab product. It would look about a bazillion times better, and you'd have still made it yourself. And you still get to use PVC!
This video shows an interesting way of doing it without a whole lot of piping.
https://m.youtube.com/watch?v=x3Z_4HrM8WY
There are many other ways of doing it, but they all operate under the same principle. I would suggest that you research a bit about the Herbie and BeanAnimal overflows. When you understand why people have come up with ways to prevent disaster, you will start to understand why most experienced people balk at the idea of the PVC overflow.
As far as the pump goes,
https://www.amazon.com/Rio-Plus-170...&qid=1470811564&sr=1-1&keywords=rio+plus+1700
this Rio+ 1700 will pump about 350gph at 4 ft, but even after factoring in elbows and pipe length resistance that may be too much for you tank. You can look at the charts to find one that matches your desired output. Rio pumps are fairly quiet depending on what you think quiet is, but much quieter than the toilet flushing sound you get with a PVC overflow.
Good luck.