I really like the German pronunciation OOR-zoo-la. I didn't like this name when I was a kid, but it has grown on me. Although I wouldn't give it to a child now, because of the Little Mermaid movie.
In England the pronunciation is "Ursyuhla", with a definite 'y' glide after the 's'. I prefer this pronunciation to the American one. It's an alright name, I associate it more with Ursula Andress than The Little Mermaid.
My mum's name is Ursula, and she can't stand people pronouncing it 'URSH-ula', she pronounces it 'URS-ula'. Also she hates to be called 'Ursh' or 'Urshie'.