If having money makes you happy, yes, yes it can.
If having lots of friends or being popular or *insert other thing here* makes you happy, then maybe not.
The usual problem is people with lots of money try to get more money, and GETTING more money never usually makes people happy.