A manifold is not necessary orientable. But the orientation bundle always exists. You can construe it as a real line bundle. Then the density bundle is obtained by tensoring the bundle of top forms with the orientation bundle. By definition, a nonvanishing section of the orientation bundle is an orientation, and a section of the density bundle is a density. Compactly supported densities can be integrated.
Locally, orientations "transform" by the sign of the determinant (of the jacobian matrix), top forms by the determinant, and densities by the absolute value of the determinant.
It suffices to understand the case of the real line.
EDIT. I've just realized that, in your question, you mention manifolds only in a parenthesis, and concentrate on $\mathbb R^n$. Open subsets of $\mathbb R^n$ are of course always orientable. But the key point, again, is to understand what happens on the real line.
For the real line, it's natural to write a 1-form as $f\ dx$, and a density as $f\ |dx|$ (say with $f$ continuous). If you have a compact interval $I$, then you can integrate $f\ |dx|$ over $I$, and $f\ dx$ from one bound to the other.
EDIT 2. You can write the standard orientation of $\mathbb R$ as $|dx|/dx$, and define the integral of the form $f\ dx$ over the interval $I$ equipped with the orientation $\pm|dx|/dx$ as the integral over the nonoriented interval $I$ of the density $\pm f\ |dx|$ equal to the orientation times the form.
So you only need to define the integral of a density over a nonoriented (compact) interval. [See for instance de Rham's book on differentiable manifolds.]
EDIT 3. In the same spirit, to define the $L^2$ space of a manifold, you consider half-densities. More precisely, you complete the pre-hilbert space of compactly supported half-densities. The half-densities "transform" by the square root of the determinant.
The general principle is this:
If $M$ is an $n$-manifold, then each action of $G:=GL_n(\mathbb R)$ on a manifold $F$ induces a bundle over $M$ with fiber $F$, called the associated bundle. If the action is an $r$-dimensional $\mathbb R$-linear representation, then the associated bundle is a rank $r$ vector bundle.
The most basic example is the tangent bundle, associated to the natural representation on $\mathbb R^n$.
Let $\chi$ be the characters of $G$ given by the inverse of the determinant. The bundles of $n$-forms, orientations, densities, and half-densities, are the line bundles respectively associated to the following characters of $G$: $\chi$, the sign of $\chi$, its absolute value, and the square root of its absolute value.
For the definition of the associated bundle, see
http://en.wikipedia.org/wiki/Associated_bundle#Fiber_bundle_associated_to_a_principal_bundle
In our case, the principal bundle is the frame bundle:
http://en.wikipedia.org/wiki/Frame_bundle