what do i need to buy to screw in this high pressure sodium bulb?

You need an e40 light fitting, a reflector, a 400w ballast and a relay/contactor to get that up and running. Nothing more, nothing less :)
 
Top