The best place to begin your visit to College Station (or even nearby Bryan) is the College Station Visitors Center. They have maps and brochures to help you plan your visit and a knowledgable staff. When I visited there were three Texas A&M student there so you not only got the benefit of their knowledge of College Station but also the parts of Texas they came from.
Please don't move to Bryan-College Station. There's really nothing of any significant interest to be found here. Why else would others be forced to mention our university as a tourist attraction? Yes, I suppose at best a half-day visit could be stretched, but what for those that actually live here? I noticed someone mentioned our mediocre mall. But seriously, what town doesn't have a mall? As a 17 year-old high school student, I've come to learn that the climax of this Boresville is a strip of bars along Northgate that allows its students to drink away the reminders about how much a disappointment the schooling and surrounding town they have chosen to pay for and live in is.