My advice would be to not even attempt it without the direct input of a structural engineer who has worked with piers before. They would know best the types of soils under the lake as to what kind of piers you can use, as well , the spacing. The depth of the slab is directly related to the distance between piers. Also, keep in mind a budget, as there are many ways to build this (all concrete, steel structure/concrete slab, wood piers w/steel and so forth)