The thorny issue of popular cities and beauty spots being inundated with visitors is something that frequently raises its head. Helen Coffey picks out some just-as-worthwhile alternatives to the traditional hotspots