For stealth? Or will they just alert everyone in the room if you use one?

Any weapon you use will alert others in a room. When you swing or fire a weapon it makes noise so it raises attention. Only silent 'weapons' would be silent casting and some offensive magic. Possibly daggers though I'm not sure.

Yes waraxes make noise.Daggers & Bows are silent.But if you are a skilled sneak and have the right gear and perks you can use a waraxe stealthily,one hit kills.

Could you share your knowledge good sir?

Take a look at the perks...and custom enchantments...