A waterfall style kitchen island refers to the countertop. On one of these, the countertop material is used vertically as well as horizontally and becomes a feature of the end of the island as well as its top.
A waterfall countertop could be used for any type of permanent kitchen island, and looks its best when the countertop material has spectacular veining.