It's full of holes yet still holds water (6)
I believe the answer is:
sponge
'water' is the definition.
(thesaurus)
I don't understand how the rest of the clue works.
Can you help me to learn more?
(Other definitions for sponge that I've seen before include "Aquatic creature; cake" , "Freeload" , "Light cake; aquatic invertebrate" , "Aquatic invertebrate -- type of cake" , "Marine creature - cadge" .)