A crime-fighting cat whose role in an undercover operation helped police catch an alleged bogus vet has been given a special award for his work.