What's a good small car that will also suit an outdoor enthuisast?

I spent 17 years in London so I never bought a car or had a car in the UK. I am a mid-40s female and ot entirely sure how I will use a car as I've mostly been "car free" and owned a car when I lived in...