I love Ophelia! I think it's beautiful and elegant - It's the name I'd love to have used but unfortunately it doesn't work with my surname. Effie is a lovely nickname if you want one too.
I wouldn't worry about the Shakespeare tragedy much, 40 years ago it might have caused some teasing/comments but the name is used much more commonly now (plus the character of Ophelia has been reclaimed by feminists in recent years with plays/films written from her point of view).
Only thing to make sure of is that your surname doesn't sound like/ rhyme with something rude or funny as Ophelia can sound like "I'll feel ya" and then kids might tease.