I opened an account WITH a bank. This means that you now have a bank account. If you use the preposition 'in', you are being literal. You are indicating to the listener/reader that you walked into a bank and opened an account. Example: "I opened an account online instead of in a a bank." You are telling me that you did not go to the bank, rather, you went online to open your account.