Fan to cool room?

Ductless Mini-split!

Ceiling fan. 

Fans don’t lower the temperature. They make it seem cooler by making air currents move and evaporate moisture from your skin. The net effect of a fan is actually increasing room temperature over time as its motor dissipates heat. 

The only solution to cool the room is to exchange chilled air for the room’s warmer air. The quietest conventional method of doing this is forced air central air conditioning. Next in line is a ductless mini-split, but be prepared for some blower noise. Last on the list is a portable air conditioner (get the dual hose type, as they use outdoor air to liberate heat from the condenser) or a window unit. 

A less-conventional method could be running chilled water through a radiant system that is more often used for heating. The heat exchange might not be rapid, but with the right capacity it could do the job. 

+1 split system. I have one in my music room. And it’s awesome. Blower motor whisper quiet. Mine is the Mitsubishi 15,000 btu. About $5300 installed.