If you failed a work drug test would you just be fired or would the cops be called as well?

I can't imagine that they have a legal right to disclose any personal health information to the police.
You'll be dismissed.
Legally speaking I don't even think they can disclose that information to a future employer