These are aquariums. This is the art of a aquascaping

This is an excellent execution of trees in aquascaping.

A more unusual and original desert scene.

Some aquascapes have "waterfalls". They typically use falling sand and a pump system which can lift it.