Major power agencies (hydroelecticity) have a max of about 10 m/s for a cement mortar lined steel pipe. Beyound this, initial imperfections in joints etc will cause spalling of the lining. BUT there cannot be ANY changes of direction, reducers, connections etc etc. So this maximum velocity is not a practical max for small pumping mains.
For a well constructed large pipeline, a practical max would be about 5 to 7 m/s.
If you have a look at Davis Stephenson's book on water supply, he has developed a graph showing that the 'economical' velocity of about 1.5 m/s for a small pipe up to 2.5 m/s for a large pipe.
What is the reason that you want the max velocity for?
Is it to protect the lining?
Is it to keep electricity (pumping) costs to a min?
Is it to limit consultants designing uneconomic pipes?