People are constantly telling me they like the sound of my 26" kick.
I have never found that big drums are louder than small drums. I actually don't get that. To me they are lower, not louder. Is an acoustic bass louder than a piccolo because it's bigger? Doesn't the drum volume depend almost entirely on how loud you hit it?
Also, people mistake "bad tone" for volume. A great sounding warm drum will rarely be considered loud compared to a plastic trebly sounding drum. It's all about tone. I've found that when people say something is too loud, what they usually mean is that the tone is inappropriate for the song.
So for a small club, I'm even more inclined to use a 26" kick because that's where you really need beautiful tone. But louder than an 18" drum? It's no louder, although maybe it has the potential to be, but it isn't any louder, it's lower. In general, lower is less offensive.