You will have odor in the room containing the plants. Period.
You can keep the odor from going to other rooms by using a high quality carbon filter, or two, or three.
Fans are not silent, but some are much quieter than others.
You will get a lot or opinions, but I prefer Hurricane fans and Phresh filters.