A Highland councillor is 'appalled' as Inverness residents in Cloverfield Park have endured severe flooding that has ruined their homes for the past 17 years.