Housing plan 'will fail Clare' unless tourist spots addresse