I have a lot of friends and colleagues with boys at Ermysteds, and the odd one at Ilkley and Prince Henry Otley.
Everyone seems very happy with all of the schools.
I’d definitely go for the Skipton area over Ripon if you both need to be in Leeds. A long commute gets you down after a while.
Living in Ilkley would give the very nice choice of Skipton grammars, or Ilkley grammar (which is a comp.) but housing is very expensive. Excellent transport links by train and a bus direct to the uni.
Closer to Leeds, Burley and Menston are a tiny bit cheaper, and you’d likely have the choice of Ilkley grammar or Prince Henry, but you might well miss out on the Skipton grammars by distance, it would be a bit of a gamble. But the fastest commutes to Leeds on the train. Burley also has the direct bus.
Otley housing is a bit cheaper too, but doesn’t have its own station, though easy enough to commute via Menston, or directly by bus. You won’t be in catchment for Skipton, but might have the option of Harrogate secondaries as well as Prince Henry. Otley is a lovely town, can be a bit prone to flooding in parts though.
Skipton itself is more affordable for housing, but the back up options if you don’t pass the 11+ are less good. Slightly longer commute, but there are some trains coming from Lancaster way that don’t stop at every single station on the line.
You could go a bit closer to Leeds down the Aire valley rather than Wharfe valley, and be in catchment for Ermysteds - Cononley or Silsden or Steeton are fairly easily commutable by train to Leeds, and you have South Craven school as your back up option.