A survey of council housing staff has shown that the majority support the closure of a controversial homeless shelter