Welcome to the site, and Merry Christmas. Although your pipe makes it not so merry.

Definately agree with esshup on the spillway.

How deep below the full water surface is this leaking pipe? In fixing this situation, I would look into a siphon/drain pipe to replace what you have now. Unfortunately any proper fix is going to take money.