After Cash the rottweiler was shot, the off-duty officer allegedly ran back with medical supplies, but the dog had already been rushed to the vets