So I can just leave money to the person that will care for the pet, right?
Sure, you can leave money to anyone, and you can instruct the person to use the money to care for the pet. However, these instructions would not be legally enforceable. Once the inheritor has the money, they would be free to do whatever they want to do with it.