Amber Heard said James Franco made a late-night visit to her apartment after a fight with Johnny Depp because she 'exhausted' her support network