Chief executive of Dublin Regeneration Authority tells MacGill Summer School of capital city ‘embarrassment’