Large-scale social housing schemes “can be dangerous and lead to anti-social behaviour”, a county councillor in Waterford has warned.