I expect fancy tanks with super-clear water use multiple methods including mechanical filters (filter socks, fleece, or roller mat), activated carbon, UV, and/or maybe even ozone. The skimmer may help a bit too.
Another cheap option is calcium carbonate powder.
Mikeymikemike on youtube has a video about this method but others have done it for years.
What I do is mix about 6oz calcium carbonate powder (sold as a supplement at the pharmacy) in a liter bottle with rodi. Once a week I shake it up very well and dose ~10ml of the white liquid per 100 gal. The tank will turn milky white which was alarming to me the first time. But after a few hours this clears up. Next day water is notably more clear. I also run carbon and a skimmer and while my water is not always crystal clear I think it's fine.
I think at some point this all becomes cosmetic. I doubt it's necessary or even beneficial from a health of livestock standpoint to get the water perfectly crystal clear...