Johnny Depp's former neighbor said the actor was 'screaming, cursing, spitting in my face' on the night he allegedly attacked Amber Heard