When you deposit a same bank check would the funds be taken out of the other account immediately?

It depends on the bank and the circumstances. The amount might be held out of the maker's account immediately or it might be taken out overnight.