If it's straight thread with a rubber gasket in the female hose end, you can mate that to NPT, no adapter needed....just buy a 1.5" NPT steel nipple...
I'd try a brass nipple with lots of teflon tape first...you can get that a lot tighter without worrying about breaking it off. If you have pvc water...