I think on a 1.4 one of the best intakes is either an BMC CDA enclosed air induction kit, or a K and N panel filter in your standard airbox. May produce a slight increase in power, but replacing filters in general will often help the engine, along with fluid changes, etc.
If you're after noise alone, I think a K and N cone produces the roariest sound but IIRC it does actually lose power.
A good search of the forum will be able to yield more results, and I'm sure there are other members more experienced than me in this matter! Hope this helps anyway!