We have a holiday home in a coastal town in the US. It was a sleepy town with lots of large properties no one wanted at the time we bought, but it's since become a very desirable place and property prices have shot up astronomically, leading to big lack of housing for locals.
A while back, we decided to try to negotiate a halfway solution and found a married couple who are local teachers who lived in the house rent free in exchange for caretaking and the understanding that we'd want to use it at Christmas and in the summers and that they might be turfed out for a week or two here and there during school holidays. It worked so well they managed to save a deposit for their own house and we're now on our second local teacher (single). It does mean we've given up quick weekends there for us, friends and extended family, but that's seemed like a small price to pay. If we end up wanting to spend significantly more time there in the future, we'll revisit.
We also use all local gardeners, cleaners, decorators, builders, etc. etc., and pretty much shop only locally when we're there (including buying coffees from the local coffee shop every day even though we actually prefer our own 😅) . We also have very friendly relationships with neighbours, go to dinner at each other's houses, keep in contact when we're not there, offer to pick up groceries, etc. We do also get involved with local causes, go to events, contribute to things whenever possible.