A compression test could tell a lot about life left. If it's got good compression, good oil pressure cold and warm, and generally seems to run good, it could be, well, good.
Can't tell you about the water pump, but it can't be major surgery...
Best Regards,
Jim