Congratulations on your purchase.
Ten years is a long time to save, I'll bet you're a happy camper!
FWIW, in some states they are pretty sticky about tires being outside the flares. Can't see where you're from, but you may want to look into it before making this decision. No sense spending good mod money on a ticket.
You might want to consider just using some wheel spacers on what you have until you figure out where you're going with your mods. I don't know a darn thing about street tires so someone else will have to advise you there but if you're looking for a tire that it good on both street and trail consider either the Dick Cepek Mud Country (I run the Cepeks) and the Goodyear with Kevlar. Both are pricey, but great all around tires. Neither are terribly noisy either.
You can achieve the look you're after with proper wheel spacing. I would suggest talking to the folks you're planning to purchase from and see what they have to say. The folks at Rough Country have about the best price out there on the Cepeks and can advise you on how to achieve your more aggressive stance by way of wheel spacing and tire width.
06 Rubi with some sort of double ended, chrome knobbed, cross threaded, infinitely adjustable, frequently breakable, worn out flammywhammers zip tied onto it.
It used to be a jeep thing... til that sh!t broke!