If you can change a plug then I don't see any major difficulty.
I would take a normal table lamp and remove the plug.
Strip some of the secondary out PVC insulation away to give you some lead to play with.
Have a look at the pump motor, I would expect to see a modest cable going to it.
Remove the cable/connector cover on the pump. The incoming wire will most likely be 3 wires, earth and the two line conductors.
Loosen the brown and blue wire connectors, add the ones for the table lamp with the incoming cable wires and tighten back up.