Will draining 100% of the water then putting it back harm any of my tank mates in any way?
Not at all. Anthony's comment about clams is especially wrong Sponges, who cares.
I've drained my tank many times to catch fish. I wouldn't even try any other way.