Hi Tricia, I live in Amble, I have lived in Warkworth, worked and went to school in Alnwick.
pros. Northumberland IS beautiful, there are some great villages with good access, GP surgeries and shopping, the cost of living is less than down south and you will be able to get a property for the £200.000 mark
cons. we get about two weeks worth of summer, we don't get lots of snow in the winter but plenty slush and rain. I have arthritis and have a hankering to move to the sun !!! to be really rural can also mean becoming isolated as we get older
so for a happy medium, check out hoopla/rightmove in areas such as Rothbury (and no, we don't get flooded that often), Wooler, Belford, Longhoughton.
Villages such as Bamburgh, Alnmouth and Warkworth can be exceedingly expensive and as you don't wish for a larger town I have deliberately missed out Alnwick, Morpeth and Amble (as lovely as they are) have fun searching xx Karen