Finally, your Sims have a place to worship their deity. As part of Update 7, Maxis yesterday released Houses of Worship, a set of four unique buildings that grant your Sims happiness during service hours.
In addition to the emotional boost, the Houses of Worship are free to place and do not require any maintenance; however, you are only limited to four buildings in a city. Houses of Worship buildings are available to all wealth levels and each house has a two hour morning service and evening service, with a different time for each to reduce strain on traffic.
You can find the Houses of Worship in the Culture menu of City Specializations view. There's a special Worship tab.