The 6502 is simply the second CPU of the 6500 family. 6501 was a 6500 CPU with an external interface (mostly) compatible with Motorola's 6800 CPU. 6503..07 were as well versions with modified external (bus) interfaces - usually less address. 6508 was a microcontroller with embedded RAM and an I/O port to compete against Motorola's new 6802.
Why 6500 was selected as family name can only be speculated on. The common ground for most explanations lies in the fact that it was basically an improved and simplified 6800, made by engineers that did work on the 6800 before. So they tried to find a 'name' sounding similar but different.