So far, my dog ignores the tank other than trying to drink out of my bucket of water change water. The cats, though....
My black and white fluff ball sits beside the tank occasionally and pats the outside, my betta swims over and flares, cat pats tank, betta flares, repeat. They will do this for 5 minutes or so before either the cat or fish gets bored and goes away. Sometimes the betta loses interst first, smetimes the cat does.
I had to get a lid for my tank, because our gray cat, Dr. Seuss, liked to stand on his hind legs, front legs resting on the edge of the tank, and hover with his nose just over the water. I figured the day was coming when he would get up the courage to actually stick his paw in and try to grab a fish, and I wanted to stop it before it happened. He then proceeded to crack my new glass lid in two seperate places by walking over it and sitting on it for better fish viewing purposes.