"Have you ever been to/in PLACE before?"
I can only give you the American usage that I am familiar with as a life-long speaker of American English. Both "to" and "in" are acceptable, no matter who is where. I'm not sure you can find a grammar book that is quite so detailed, but if you do,...