Bristol City Council has been ordered to fix long-standing issues in its homes