You should be able to rent an apartment at decent rate that is close to campus! Don't live in Lafayette while it is harder to go back and forth from campus. Also, apartments in WL area are clean and quiet.
What is your budget?
I would suggest you look at Beau Jardin, College station area. Those two areas have markets within walking distance and are right on bus route.