Motor Technical Reference, from Leeson
http://www.iprocessmart.com/leeson/leeson_technical_reference.htmpdf file, "What do all those things on a motor nameplate mean?" from Allen-Bradley
http://www.ab.com/manuals/dr/Motors/Motors9_2.pdfYour motor might be what's called a "Definite Purpose Motor" which means it's a special animal designed specifically for heavy duty long distance water systems, which means you'll be lucky to find a close match in the catalog you're looking in.
I'm not an electrician & I don't know about water systems, but I am an electrical controls engineer who has to design systems that run pump motors in industrial environments. So I can definitely state a few things:
You don't need a brake motor, or a gearmotor for that matter.
If it's three phase, the power cable going to the motor will have three conductors plus a green-insulated ground conductor. If you have fewer conductors than that, it ain't three phase. Check the old motor's nameplate for a wiring diagram. If it's not there take the cover off the "peckerhead" (small box where the power goes in) and look inside the cover for a wiring diagram. Compare with your catalog.
If I was involved in replacing an existing motor for a pump, the easy way would be to have the salesman find an exact match or look up his line's closest cross-reference. A couple things that must be taken into account when specifying general-purpose motors for pumps: Motor dimensions and mounting - the "frame size" and the design of the motor where the shaft comes out must be the same as the old motor or they wont' fit together. Speed -- Fast motors have a synchronous speed of approx 3450 rpm, give or take a few, and slow speed motors have a speed of 1725, more or less. For pump applications you can't interchange one for the other or you'll have half the flow you need or you'll trip circuit breakers or something. Ditto for horsepower. And of course the voltage must match your supply voltage. And environmental considerations -- see the "construction" discussion on page 7 of the pdf file.
In my job I always, always see general-purpose three phase motors that can be connected to 230 or 460 VAC, which require protection by an overload relay or some other means, so I'd also have to consider the implications if the Full Load Amps of the new motor was different.
Since I'm guessing yours is a "definite purpose motor" you can probably forget most of what I said in the last two paragraphs...