Crew members from North Berwick RNLI and the coastguard rescued the weimaraner, called Sparkle, after the incident at Seacliff beach in Scotland