Have you full thought this through?
How will you fund it? Buy outright, or with a mortgage? If you don't rent it out, can you afford the mortgage payments?
As it is a second property, you would pay extra stamp duty, another 3%, so a significant cost.
Buying it is the same as buying a house, its irrelevant that its a second home.
Looking at area, where do you want to live, when you retire, as that surely has to be the key factor in deciding where to buy?
Look at the property websites; Rightmove, Zoopla, Onthemarket, and also contact agents in the area you want to move to. Explain what you are looking for and your budget.
Are you financially secure otherwise, e.g. do you pay in to your pension, have savings, have an emergency cash fund to cover unforeseen expenses, etc..
Are you going to have to fund your children through university, if so, could you do that as well as paying the mortgage on the second home?
Lots for you to think about and decide before taking this further