I went to RGS, DH went to Ripon College.
Ripon College is OK for some people but, at the time (a fair while ago), no good if you needed an extra push - like DH. Him, his brother and most of his A-level class failed their A-Levels. I would strongly recommend not sending your child here from our experience.
RGS was fantastic. Everything from the teaching to the extra curricular activities. I, and many of my friends, got all As at A-Level and I went on to study medicine at university (However this was not the case for everyone).
I did not live in the catchment area. Anyone could apply to sit the exam and most of my friends were from out of catchment areas, although not borders. However, I believe the 11+ pass mark for those out of catchment is slightly higher than for those in catchment.
I would recommend moving somewhere between Ripon and Harrogate like Burton Leonard or Wormald Green, or even Ripon itself as then you've the best of both worlds - RGS if your DCs pass the exam or some of the great schools in Harrogate like St. Aidens. St. Aidens is also a fantastic school, although I think they only take a few, non-faith pupils. I have many friends who went here and did very well.
My brother went to Upper Nidderdale (in Pateley Bridge) and my DH did work experience there. They have some fantastic teachers.
I can't recommend RGS enough - I had seven happy years there.