Any and all films can be scanned. There are a few considerations, though. First, 35mm film will not give great results when scanned unless you're using a dedicated film or slide scanner. Here are some general principles about scanning film:
1) Slide film is by far the most difficult to scan, because it has a huge density range. In other words, you can have a whole lot of detail in very thin (light) areas of the slide and in very dense (dark) areas of the slide. This presents a challenge for scanning, but generally 35mm film scanners do well.
2) Color negative film (print film) is the easiest to scan because it has the lowest density range (which is why it has the highest dynamic range). The difficulty with negative film is converting the inverted image with its orange mask to a normal image, but most scanners have software that can do it for you.
3) Black and white film is generally easy to scan unless you have some very dense regions (i.e. overexposed).
As for film choices, the easiest for you to get processed will be C-41 films, which are color negative films plus a couple black and white films (Kodak BW400CN and Ilford XP2 Super). But that doesn't mean they're the best. Black and white films and color negative films have HUGE dynamic range. Slide films have tremendous color rendition.
Here's what I like to use:
Slide films (E-6 processing)
For portraits -- Fujichrome Astia (this may be my overall favorite film)
For scenery -- Fujichrome Velvia (gorgeous color, high contrast, high saturation), Fujichrome Provia (same as Velvia but slightly less contrast and saturation), and Kodak E100VS (similar to Velvia, but better purples and greens)
Color negative (C-41) films
These are some of your options:
Kodak -- Portra 160 NC and Portra 400 NC (natural color), great for portraits
Kodak -- Portra 160 VC, Portra 400 VC, Portra 160 UC (more saturated, better for scenery), there may also be an ISO 800 Portra but I don't know
Fuji -- Reala (a good all around film)
Fuji -- 160 Pro-S and 400 Pro-H, relatively unsaturated, good for both portraits and all-around use
Fuji -- 160 Pro-C and 800 Pro-Z, more saturated, good for portraits and great for scenery
True Black and White films
Traditional emulsions:
Ilford FP4+ (ISO 125) and HP5+ (ISO 400), Kodak Plus-X 100 and Tri-X 320 -- as good as any film gets
Modern emulsions (less dynamic range, less "magic" to them, but smaller grain)
Ilford Delta 100 and Delta 3200 (great in medium format), Fuji Acros, and Kodak Tmax 100, Tmax 400, and Tmax 3200
Also the two C-41 black and white films I mentioned above are excellent and you can get them developed at your local drug store.