You could refer to the specific codes, such as AWWA, ASME B31.1, B31.3, B31.4, etc. for the selection based on allowable stress and temperature limit for the material.
Then, you may choose the material in the same category (high/medium/low strength) based on the availability and cost. Also, you could simplify your selection to one or two types, so it won't cause any confusion or mistake during construction.