You can get hotel type accommodation (Huntley, Summit, Lodge at Big Sky) right in Mountain Village, or you can rent a condo over off the Lone Moose lift or any number of rental house options between Mountain Village and Moonlight, some of those being more ski in/pole out or pole in/ski out but still doable.
Another decision is if you want to rent a car or not. IMHO, the only way to do without a car is to stay in Mountain Village. If you are in one of the houses towards Moonlight, you really need a car as Big Sky is sorely lacking in bus service.