There are a lot of great small colleges in the Blue Ridge Mountains that are great for mountain biking, but probably not great for road cycling and not great for a casual bike rider who likes flat paved paths.
Brevard, Warren Wilson, Lees-MacRae, UNC-Asheville, Appalachian State are all great for mountain bike loving kids.