Tell us about yourself!
I have done this and it works pretty well. I can live without it being aesthetic . I think the fly killing part is the more important feature.
So long as no one around has been spraying anything on the flies that could work well. Might be worth an attempt to to use the little dried up fly carcasses as fish food. Back when I was keeping fish I made a mosquito hatchery outside. I would harvest mosquito larvae on a regular occaison. I'd then net out the larvae, rinse them dump them into a jar and from time to time net out a portion and drop them into my aquarium. The fish loved them and to the best of my knowledge none of the mosquito larvae matured and escaped. (I am apparently very tasty to mosquitoes so I am certain that if any adult mosquitoes had escaped I would have been painfully and itchingly aware.
https://www.google.com/search?q=glass+fly+trap&esp...I believe glass fly traps have been around for awhile.
3d Nocturnal Celestial Stardial TJT5/6
Fluorescent Tube Floor Lamp
How to create earrings using blown electric fuse
DIY Nontoxic Wood Stain
Wooden, Cyclone Seperator Shop Vac
Better than Chicken Nuggets
bake a whole chicken in a slow cooker