I love the name
Louisa. It's pretty, classy and not too popular but not unheard of either. I'd pronounce it Lou-ee-za.
Louise is ok, but it's been really popular and I find it a bit boring. It's especially boring as a middle name but if it has significance for you then that's fine.