The private estate and studio complex of the late rock superstar Prince will open for daily public tours from October 6, it has been announced.