The specially trained 2-year-old golden retriever joins fellow hospital canine, Hope, in providing comfort to patients, families