Hi! I lived in Yorkshire for about three years and am currently looking at moving back to Leeds! I was born & raised in Texas so getting used to the weather was a bit of a process but it's all relative to what you're used to. Its not the cold that got to me anyways, it was the winter grey!
The Ilkley/Otley area is really nice but as previous posters have mentioned the traffic can be pretty bad. Avoid Keighley, Bradford, and Dewsbury. We are looking to live in the Tadcaster area. Wetherby would be ideal but unlikely.
In regards to making friends, I never really had much luck so I got a dog