We are at the end of a basement remodel on a 1950's ranch have a floor drain that I need some help on how to address.

There is a rough 4 1/2" hole in the basement floor [4" concrete slab] over a clay tile that is T-shaped and runs horizontally. The tile has water sitting in it, approximately 8" below the top of the floor. In the 10 years in the the water level has seeminly remained at the same level be it spring, summer, fall, winter. There is a slight amount of moisture where the clay tile T butts the bottom of the conrete but not a dripping condition.

How is the best way to "plug this hole in the floor"? We are planning to install carpet so I do not want a floor drain visible, but I want to be mindful of the need if there basement ever flooded I could use this drain to deal with water. I am talking if a water pipe busrt or such.

Thanks!