I live in one of the 'villages' on the Ilkley train line.
A65 is busy - but then show me a road into or out of Leeds that isn't ! At least living the right side of Leeds towards the dales cuts out a lot of driving through suburbia when you do want to get away.
Schools are all good round the area - not sure why the downer on Guiseley schools - did you included Tranmere Park in that assessment? My knowledge suggests they are all 'good' and more than their fair share are 'excellent'.
Train service to Leeds/Bradford is by far and away the most convenient way to get to work but if you wanted to cycle there is the canal tow path down Airedale or off road routes via the Chevin/Golden Acre Park/Meanwood Valley.
You can see planes taking off from LBA from my garden - fortunately it's still a regional airport and long may it's development be stalled
But most importantly the local riding is excellent both on and off road.