You are correct to use the NO contacts. But this means the relay will be open until it is energised. "Open" means the relay contacts are open and no current can flow to power the pump. When you energise the relay, the contacts will close and current will flow to power the pump.