Most of rope climbing is about technique, and using your lower body to push yourself up the rope, rather than 'brute forcing' it with upper body strength.
Pull-ups are pretty good training. www.sparkpeople.com/resource/fitness_artic
. Squats and deadlifts as well.
Can't help you with where to find a rope.