Omar the reason you weren't getting the mist is that your holes weren't big enough there was too much air pressure for the pump to push the water up. I just tried and used a pin but there wasn't any water being forced up the line so I made the holes a little bigger and then used a knife I cut slits into the hose. This worked the pump was pumping the water up the hose and it was trickling out so now I have to make the holes a little smaller so that it is a mist and not a rain effect haha but it was a good first attempt.

As for caping off the end I just filled the end with a 1" of aquarium silicon I had left over from my tank that worked fine after drying for 24 hours