If it is a compound you are staying in, there will probably be home-brew at weekends and you will probably partake as well given there isn't a great deal else to do.
Many of the strict laws are flouted but getting caught is very serious. It's a very restricted society and prepare to feel trapped by it, moreso as you are a 2nd class citizen to most Saudis. You can drink in embassies as well but it is ridiculously expensive. You can go driving in the desert which is fun for a while. Lots of people go to Dubai for weekends of debauchery.
Getting anything done, especially by public officials, is difficult as well, they will tell you "tomorrow, if God wills" which you aren't allowed to argue with and generally means they will do something when they can be bothered which isn't often.
The security threat is very real, lots of what is happening in Saudi goes unreported here.