Even if it's just the two of you, your wedding can be as magical as you want!!
It was just DH and me when we were married. Of course, we weren't really alone...the officiant is there, your coordinator, a violinist (or whatever musician you choose), and your photographer. We also had a 'server' that served us the champagne and cake after we cut it.
Nearly four years later and I still think it was the best! We did call my mom on my cell phone and my coordinator held it so mom could hear everything...but the bottom line was, even if we were there by ourselves, we weren't really alone...all the love from all the people in our lives was there with is. In us.
Don't worry if the location seems 'too big' or 'too much' for just the two of you. It makes it all the more special and intimate.
There have been quite a few brides over the years who have had VERY small ceremonies...only a few with just the bride and groom, but quite a bit more with just the bride and groom and their children, or bride and groom and their parents.
If it makes you happy, that's all that matters!