It is normal practice to show the plan view in a true orientation, 40 years Civil Engineer, but in saying this you are asking for a over the top solution when a simple answer is actually available and that is to use a ucs in your viewport that covers the range of the long section.
This type of approach is built in to software like CIV3D Civilsite etc. They auto make the layouts and work out the ucs orientation.
Ok manual way very easy, draw a line from start point chainage to end chainage of your pipe for each layout section. Check that lines have Z set to 0 use properties, take your long section layout add a mview, go into view say zoom e, then UCS OB select match line section, pick left side, then type plan, your view will rotate to that orientation, set viewport scale and your nearly there, pan to approx. long section. Ok now to align a chainage, simply draw a vertical line in Mspace from a chainage of your long section, you can "move" the mview window select the correct chainage point of the mview stay in mspace then use say perp and the mview will be correctly aligned. Lock viewport, next viewport you may need to type UCS W Plan to reset view orientation.
Yes it could be automated.
For all those that have posted sorry but the solution exists in that you can take a pline and set spacings and auto create mviews on multiple layouts this code has existed for a long time.
