The holiday let hotspots bringing the best yields for investors