We have a second home which at the moment we use at weekends and for longer periods in the school holidays. I think you need to distinguish between two things-
- pros and cons of owning a second home
- pros and cons of running a holiday let
You also need to think which this will be, primarily, as you will want to make different choices depending on that.
For us, we have never considered letting so have been able to make all the choices we want- there are lots of things about our house that make it unsuitable as a holiday let (unfenced pond, narrow 16th C spiral staircases etc) but absolutely lovely for us. We will retire here hopefully in 4 years.
Disadvantages are tax (extra stamp duty, extra council tax- totally fair IMO) and the fact that you need to run two houses- some costs will double up (eg broadband, TV licence, insurance- this can be even higher for a second home) and some will be higher than for one house (eg heating- you might not fully heat a house when you are not there but you need to keep it above a certain temperature or you'll get mould). I also find that we regularly have to make unexpected trips here eg to wait in for a plumber or take delivery of something. I also find that it's hard to run both houses totally smoothly- I'm constantly forgetting which house needs kitchen rolls etc and end up with 20 in one place and none in the other.
For a holiday let, obviously you'll be making some income and that might cover the costs of someone local to manage the house, but you may find that you dislike the compromises you need to make to balance the house seeming like a home and being suitable for paying guests. I would also find it hard to feel fully at home somewhere where strangers were regularly sleeping but that might just be me.
You also need to think about location. If it's primarily for you to use, how accessible is it? Can you realistically get there enough to justify it? If it's further away and will mainly be used by others then that's less of an issue.
Basically I think you need to be clear in your head what the main aim is- is it to have a second home for yourself (which you occasionally let) or is it to have a holiday let business (that you occasionally use) because it will make a big difference to what set up will work for you.