I will second everything JohnK says, from a small rural community in the heart of Wales.
I think one of the big misunderstandings about second homes holiday homes is that they prop up local business and bring money to the area. They may bring some summer money to a community, pubs, local shops, cafe but there is a downside.

They don't live in the community, so the majority do not contribute to the local community - help with local shows, celidhs, parties, orginsing quize nights - they may attend but there is more to a community than attending, you need to be a part of it.
A house that is occupied 100% by a family also contributes to the local businesses, the pub, the cafe, the shops and it does so 365 days a year, not just weekends or summer months. So which is better for the community? And a family may have kids to go to local schools (they all close down now), maybe the church, the clubs, jobs, care for elderly neighbours, there's many ways a resident home is better for a community than a holiday home.

Some people with these homes put themselves out and really help over the years and are accepted, but I fear most don't and contribute little to the core of a (half empty) village, they take and think a few ££s is giving.