Alcohol at the reception

Hi everyone! I would really like some outsider's perspective on this topic. My fiance and I are having a conflict where both of our families have different points of view on alcohol. My family is very religious and also very against alcohol. His family is the exact opposite and drink with any occasion. We would like to have alcohol available at our wedding but due to my very religious side, I think there is gonna be drama. They are old fashioned and my grandpa is a baptist preacher. Although I am christian, growing up I never really saw an issue with drinking moderately. I want everyone to have fun at the wedding but I feel like I am gonna have to pick a side. When I mentioned it to my grandma she stated that I should have "god on my side" and tell them no. Although, that seems easier said than done I don't want to do that. I am trying to make everyone happy but it is frustrating because I think this issue is gonna ruin our special day due to my family being so stern on how they feel. My mother mentioned that if it were my brother getting married and his wife's family paid for the wedding then they could not have a say in if there was alcohol involved. To me, this is so unfair. I do not know why money has to play in it at all. So my question is to you guys, what options do you see here? Do my finance and I pay for the wedding ourselves? Do we ask his family to pay? Also, I should mention that my family would not want to be around drunk people. Yes, I know what you're thinking, trust me I know. It is hard because I love my family but they are so strict in their ways. Some part of me just wants to skip having a reception.... but I have dreamed about this since I was a little girl. I might be overthinking everything but I just don't want to be upset on my wedding day. I am trying to plan ahead while I can but I feel stuck. Any ideas would be helpful. thank you.