Generally you want the best stickiness. Bulbapedia has a list of the berries and scoop/stickiness. None of them create great stickiness all round but these berries get you 3, 4 and 5: Cheri, Chesto, Pecha, Rawst, Aspear, and some of the 'legendary berries' which I don't think are available in B/W.
So any of those 4 I would say are the best.