Bill Cosby and Johnny Depp both have homes in my area.
As for local celebrities who not everyone might have heard of, the celtic folk music scene around here has produced some pretty amazing musicians who have gone on to national fame, like Jay Ungar and Rod Miller.