I had one for a few years in my old house. Be aware it will freeze solid in winter. I also had pump problems at times (needed for filtration ) and ended up with empty tanks. Sit your pump on bricks so you can't completely drain it down when there are issues
I'd like something like this on the decking as a small pond. Is there anywhere I should be looking for a cheaper/better alternative?
https://mcveighparker.com/livestock-water-trough