What type of creation story describes how earth originated from water?

Earth diver myth.

Explanation:

There is a type of traditional myth called "Earth diver". This includes creation stories in which there is a supreme character who sends another individual to find some sand among the water. Using that sand the divine character builds or forms land. This usually explains the beginning of the creation of land and how life on the land start