Any battery of the correct grouping will be fine. I've purchased my last few at Sam's and have been just fine.
They will come with venting accessories to vent the battery OUTSIDE the cabin. You will see the vent hooked up to your current battery upon removal. It's a small tube (like small vacuum tube, but grey if OE) that connects to the battery. There will be 2 vent holes on the battery, plug the other side with a plug that should come with the battery.
Edit: This is what I have had in the E53 X5 for the last 3 years. So far so good...
https://www.oreillyauto.com/detail/b...6/bmw/x5?pos=2