He drank with Sartre, mocked Picasso and took silent walks with Beckett – but his work was going nowhere until a vision on Boulevard Montparnasse left him trembling. Ahead of a major Tate show, we explore the obsessions of Giacometti