If this were a separate building on land, with the first building feeding power to a second building, and if you installed a transformer in the second building, there would not be a need to run the GEC back to the first building. You have a separately derived system that requires its own grounding electrode system. You would put a ground rod (or two) at the second building, or use whatever electrodes are available.
I do not know a Grounding Electrode System is designed in the case of a floating pier. Yes, I do believe a ground rod or two pounded into the bottom of the lake would constitute a valid grounding electrode. But I doubt it is often done that way. If you can bring GEC to landside, and put a rod (or two) into the ground near the head of the pier, that should suffice.
But I have never gotten that deep (pun intended and not regretted :roll: ) into the design of a marina. I do not know how this is normally handled. Someone else will have to finish this story.