Tourist hotspots set to double council tax for second home owners