I think a lot of it has been said, but I wouldn't DIY a UV. In a location like an overflow, the dwell time of the water is going to be pretty low, so you're going to need immense amounts of UV output to get a reasonable dose, and the partially submerged nature of the location would lend itself to cooling problems if your flow drops - especially bad with large lamps.
You've also got the issue of effectively shielding the outside from UV. I want to emphasize this point because it's easy to underestimate, but ultraviolet radiation used for sterilization is an ionizing radiation that is dangerous to be exposed to - the deep UV bands used for sterilization are worse for you in smaller doses than bad UV days outside and can absolutely lead to cancer and burns. Because of the wavelength and our eyes, we also can't actually tell what's transparent to UV or in what intensity, since the glow we see is a secondary fluorescence effect of the actual wavelengths doing the work. You really need a UV inspection system to be able to even verify that no UV radiation is getting out of the enclosed space, and you would need - at minimum - high grade eye protection to be working around an open UV sterilization lamp, and likely full skin covering to keep yourself from being overexposed.
Of course the risk to humans is similar to other animals, so stray UV leaks into the display could damage or kill your livestock as well, even though the penetration of UV through water and glass isn't especially high.
The point being that it's much more dangerous than it appears because we literally can't see it, so if you're considering constructing something that uses UV, you really need to know about the dangers of it, the output of device you're using, the considered safe limits for exposure, the UV transparency of the materials you're using, and more beyond the basics of construction required for a normal DIY. I consider myself fairly well versed in the dangers of ionizing radiation, the kinds of materials that can block it and the kinds of damage it can do (including to many plastics), and I have appropriate eye protection (OD 7+ UV laser goggles), and I wouldn't attempt to DIY my own UV, let alone outside of a sealed black housing (as most manufacturers use for good reason.)