I have location with minigames where you can gamble money planned for one of the major settlements. I also want to add one gambling NPC into the Riverstone pub, but this will probably take some time. Making minigame like dice and slot machines is quite easy, but anything with and AI, like card games, will be much harder. It is planned though.
I will add more ways to increase mood, but these will still be limited in some way. Simply don't want to allow players to go from -100 mood to +100 in a single day. It was way too easy to do this in previous versions. Wellness fixed that a little.
Technicaly, drugs and alcohol are a way of using money to raise mood, but I will add a more direct ways. I have a plan to add locations like a theatre / cinema and events like a band playing music in the pub. The former will have to wait for the map expansion, the later will be implemented rather soon.