Simple & intuitive explanation of superfluidity? I know that superfluidity is caused by the fluid having zero viscosity. This only happens at very low temperature, so the fluid (e.g. Helium-4) is a Bose-Einstein condensate.
I also know that in a Bose-Einstein condensate all the particles are in the ground state.
Now, that said:


*

*How can this explain superfluidity? Many websites just say that the particles behave as one [...], but what is this due to?

*Superconductivity is due to Cooper pairs, which being composed by two fermions are actually bosons. Is a superconductor a Bose-Einstein condensate? If not how come the Cooper pairs move without any electrical resistance?
 A: I will answer your second question because it's the one with which I'm more familiar.
The question we're answering is: "Why does current in a superconductor move with no resistance?"
To understand this we should first understand why normal metals have nonzero resistivity. Imagine an electron in the metal and suppose it is traveling in some direction. If the electron never interacted with anything else then it would just go along merrily in that direction and in fact the resistance would be zero. However, in a normal metal the traveling electrons interact ("collide") with the ions of the metal via the Coulomb force because they're both charged. This transfers energy and momentum from the electron to the ion. Since that ion is tightly connected to the other metal ions, this energy and momentum transfer causes the lattice of ions to vibrate. An excitation of this kind of vibration of the lattice is called a "phonon". When you will hear people say that, in a normal metal, electrons scatter off of phonons, this is what they're talking about.
By the way, excitation of phonons is precisely heating of the metal, so we see that as the electron loses energy the metal heats up. This is Joule heating.
So, we can say that in a normal metal the resistivity is non-zero because the electrons scatter off of phonons. In a superconductor you'd think the situation would be the same. There are still vibrational modes in the metal, and the electrons and ions are still charged so of course they still interact via the Coulomb force. To understand why this doesn't happen we have to more carefully consider what's going on in a normal metal.
When an electron scatters off of a phonon the electron's state (ie. it's direction and speed of travel) changes. Electrons are in a class of particles called Fermions. Fermions are subject to the Pauli exclusion principle, which is that it is impossible to have two Fermions occupying the same state. That means, for example, that you can't have two electrons in the same momentum state. That means that in order for an electron to scatter off of a phonon, we have to have a situation where there is an unoccupied final state into which the electron can scatter. Otherwise, the scattering process simply cannot happen. In a normal metal at finite temperature, the electrons occupy a set of momentum states up to a certain level. Think of it as follows. When you put the first electron in the system it goes in the lowest energy state (which is at zero momentum). Because of the exclusion principle the next electron goes in a higher energy state, which also has more momentum. As you continue to add electrons you fill of a 3D ball of momentum states. This is called the "Fermi Sea" and is illustrated in part a of the attached diagram.
At zero temperature the electrons would fill the ball up to a cutoff energy. This is shown in dark red in the diagram. However, at finite temperature there's a bit of thermal energy that allows the electrons to jump around to slightly higher energy (and momentum) states. This little band is shown in pink in the diagram. In part b we zoom in on the pink band. The dark circles indicate filled electron states and the open circles indicate empty electron states. When an electron interacts with a phonon, it can only scatter and change state if there is a final state available. The green arrow indicates a possible scattering process, while the gray arrow indicates one forbidden by the exclusion principle.
In a superconductor, something really interesting happens. Because of interactions with the phonons, it turns out that there's an effective attractive interaction between the electrons! Basically what happens is that a traveling electron with its negative charge causes the positively charged ions of the metal to get sucked together a little bit. The electron leaves really fast, but the ions take longer to move around, so after the electron is gone there is still a region of increased density of positively charged ions. This causes other electrons to get attracted to that point, because of the higher positive charge. In this way, there is a weird time dependent attraction between electrons.
The attraction between electrons makes it turn out that there's a lower energy state than the filled red region shown in part a of the figure. This lower energy state is such that the usual single electron excitations are at an energy level that is a significant distance away from this new ground state. The gap in energy, shown in part c of the figure, is the reason that superconductivity happens. Now if electrons were to scatter off of a phonon, the only available states they have to scatter into are a large distance away in energy. That means that you need really high energy phonons (or something else) to disturb this ground state. So, as long as you don't whack your superconductor too hard, there's is NO scattering, and thus no resistance.
This argument also explains why superconductors have zero resistance at DC, but nonzero resistance at AC. If you put in high frequency perturbations, you can introduce enough energy to actually kick a superconducting electron out of the gap into those available states in the pink region. Remember, the energy of a perturbation is related to frequency by $E=h f$.
Summary: Superconducting metals have zero resistance because there aren't any available states for electrons to scatter into. No scattering means no resistance.

