But if you really want a "zero noise" solution you shouldn't upgrade your case before you change mainboard and CPU as well. Today you can build systems without any fan and for this without any noise at all. But those cases are mostly for µATX/Mini-ITX Boards...
All "better" cases are without Power Supply. So, no there is no Power supply shipped with... Fans are most often been included but I recommend to try it first without them. Those fans are normally not that silent so if you really need them I would recommend to replace them by some with less noise...Do these cases come with fans and power supply?
Those cases are expensive most of the time, mainly due to high end materials and the CPU cooling system bundled with. One of the cheaper ones is the Streacom FC8-EVO:Could you give me an example, please? If possible not the high end solution but something at reasonable cost.