I do freelance, contract, and consulting work - so sometimes clients will ask me to work from their offices, but the majority of the time I'm working with my own computer from my own environment. Working from different environments has pros and cons, but I think you'll be able to make the most of the new flexibility you'll have.
I find that creative work has a few caveats, for me at least:
When I was working 9-5 in an office I would usually have one good creative period in the morning, and sometimes another little creative burst near the end of the day, but there was a dead zone in the middle of the day where no matter how hard I tried, I was pretty useless for anything creative. I would try to schedule my day to take advantage of creative work during the creative times, and do routine boring tasks during my non-creative times, but I was still missing out. Normally I'd have another creative burst in the evening, and another one late at night - but by working all day I was just exhausted by 5pm and too tired to do anything creative at night.
When I left the office and began working in my current arrangement I also had the flexibility to work any time during the day that I wanted, so naturally I began to break apart my work day to take advantage of the 3-4 creative periods and do non-work life things like errands during my off times. This meant I could capture more of my creativity each day and still get the same stuff done.
I find that when I leave the house to work, I often set a goal and don't return until that goal is complete. This kind of goal-oriented sprinting by changing my environment keeps me focused and lets me get a lot of work done in a small amount of time.
Another bonus about being able to change environments is that if there's something negative or bad happening in one, you may not have the power to change it but you do have the power to leave and work somewhere else. It's great to have options!
If you are going to be moving into an office space where you have these different environments available to you, I'd suggest switching up your location 2-3 times during the work day, setting goals for each one. Don't linger or lounge—focus, get stuff done, and then get out of there! :)
You're fortunate to be joining a place with some variety, I'm sure different spaces will inspire you in different ways!