We had a good one like that in our previous apartment. They consist of a large cylindrical metal "heat sink" where cold air coming in goes through the bottom half, warm air going out leaves through the top half, and the entire thing rotates at ~ 5 RPM. Not any more noisy than regular kitchen ventilation. But they need to be big, ours was the size of a small dishwasher and that was adequate for a 75 square meter apartment.

Edit: if you are buying such a thing you should get someting oversized, e.g. for a 180 square meter home you should find a unit that is specified for "200 to 350 square meters", not "75 to 200".