Emily Thornton-Sandy, 30, and her dog Scout died after a crash on the A48