I shall humbly request a hint for the dog and what the sand pit puzzle was supposed to be.
You have to dig all the sandpits to get the password from Douglas Gargoyle
The dog can be talked to, the rest you must figure out yourself. Good luck agent.