How do I make part of a texture transparent?
You can connect it like this:

NOTE - your image has good black and white cutoffs, so you probably don't need the ColorRamp for the alpha, but in case there's more gradient, that's how you solve it. Also, pay attention to the blend modes I've highlighted. You can pick anything to your liking, just not opaque.