Estate agents in some of the UK’s most popular tourist destinations are reporting a sharp decline in demand for second homes, driven by recent council…