The Mission Ballroom opens on August 7th and will feature designs from local artists all over the venue