Any type of cement can be used as long as the design and durability requirements of the concrete used to construct the pile are met. For instance, if the sulfate attack is expected, it is desirable to select sulfate resistance cement because it produces concrete that withstand sulfate attack. As a result, the produced concrete would durable.
You can visit the following link to read more about Applications of Different Types of Cement for Concrete Construction:
https://theconstructor.org/building/applications-cement-types-concrete/7686/
The ACI code 318-18 provides the design and durability requirements of concrete.
Design Requirements of Concrete Based on ACI 318-19
https://theconstructor.org/concrete/design-requirements-concrete/39004/
Concrete Durability Requirements Based on ACI-318-19
https://theconstructor.org/concrete/concrete-durability-requirements/39036/