Does this pump need mains power on site?

No - it runs on its own diesel engine, making it suited to sites without a reliable power connection yet.