Neighbours claim local people were picking through the debris for items that might help with cannabis cultivation after police raid led to clearing out of council home