A statue dedicated to Tip the therapy dog, who died suddenly in 2019, has been unveiled at South Tyneside District Hospital.