My English Cocker used to love the tanks at the aquarium! he could sit for hours (if we let him, strictly speaking he wasn't supposed to be in there at all, but I used to take him when I was doing early morning tank checks)
To clean the slobber off the tank,we used windolene (but these are sealed tanks )you would need to be really careful not to get any in the water. I'd recommend putting some on a cloth and then wiping the glass rather that spraying it directly onto the glass, a weak solution of vinegar in water works well too.
Love your Pointer...........go gundogs!!!!
D the idea of Newf slobber in a sump............

we used to show our dogs and occasionally one would get newfed on the back....usually just before going in the ring

that stuff is sooo sticky!!!!
J