The weather in Sept is usually pretty nice in MB. Warm days and cooler at night. You'll be able to enjoy the beach. It's not cold yet.
Coral Reef is a nice place to stay, you'll enjoy yourself.