You apply to whichever water board it is and they supply the pipe.
Normally you pay a deposit and then pay for the water you use, some offer a flat fee though.
You used to be able to buy generic standpipes but not sure if you can now. If you get caught using a hydrant without permission and an unlicenced standpipe you can be in for a pretty hefty fine so don't risk it!
Andy