Up to 50 people were forced to spend the night in temporary accommodation after homes were flooded with sewage in Belfast.