If you are going to tear the motor down far enough to get to the rods, you may as well rebuild the motor while it is out, as the other rods/bearings may be in bad condition as well. Depends on what you want as of cost. If you just want a "quick fix" then maybe $800-1500 for a mechanic to pull the motor, disassemble, test components and only fix that particular problem.
For another $1000 though, you could rebuild the motor with some quality components and have a "like new" engine.
It may be cheaper to find a low mileage used motor and just have them drop it in! Search Ebay or some salvage yard sites for motor prices and assume $500-$800 from a shop to swap it.