If you have the resources and time, you can create almost any aquatic environment you want. One of the aquarium shops here in Phoenix has a small river environment with goldfish, and lots of outdoor ponds have streams. Biotype aquariums are also part of the hobby. In those, people try to create an environment that closely matches a specie's native environment.
All those things can be fun, and each aquarium fish needs correct water parameters. However, nearly all of the fish sold to the aquarium hobby have been kept for many generations in an aquarium environment or raised on a fish farm. Many of then have little resemblance to their native species. Most are well adapted to aquarium life.