Are you proposing to hang the pipe from rods embedded in the deck? Typically water mains on bridges sit on steel supports, though on one project I had to mount a 12” pipe to brackets mounted to the parapet.
The loads are no mystery. Weight of pipe and water, impact, perhaps wind depending on how you mount the pipe