Orange County Floor Kitchen Bath

OK, I have a 13-14 yr old female Golden, Heather, a 4-5 yr old female Great Dane, Princess, and a 6-7 month old male Pug/Malteaze (I probably didn’t spell that right) mutt, Rascal.
My first problem is with Rascal. He urinates everywhere. He does have blatter control. He’s proven that by holding it when he’s on tile, or when an adult is there, but the instant he is on carpet, and he doesn’t think an adult isn’t there, he’ll go whenever. He doesn’t even stop to squat or lift his leg(like he’ll do outside) he’ll go while running around, jumping, laying down. The only reason I know he does half of this is because he’ll do it infront of my lil sister, the spots I keep on having to clean up, and the guilty look he gives me when he knows he’s in trouble. I’m not sure what to do, he had better control when I first got him.
He also won’t stop barking, it’s gotten to the point I’ve been thinking about having his voice box removed but I really don’t want to do that. I’ve tried using one of those collars that sprays a lemon scent in his face when he barks. He didn’t like it, but he barked anyway. He killed the battery on the thing in a matter of days. I really need help with this one as I need to be able to sleep at night.
I also can’t walk him because he’ll suffocate himself. H’s pulls on the leash so much that he chokes himself and he’ll do it till he drops. He’s done that ever since I got him 4 months ago.
Next is my Great Dane. Princess is a great guard dog and very smart. The problem is that she likes to run off. She’s already figured out how to get out of a harness and choke chain, and she keeps on breaking chain leashes. She’ll come back to the house within ten minutes and then will try to hide because she knows she wasn’t supposed to do it.
She’ll also raid the trash and counters when people aren’t looking, and will once again try to hide when we find the mess. We’ve tried a shock collar on her, but she just shakes off the shock.
Lastly there’s Heather, my old girl. She’s a good girl, she just has a licking habbit. She’ll lick her paws bleeding raw. I’ve tried bitter apple, hot peppers and a number of other thing, but she likes them all. I bandage her up but she rips them off.
I think I got the basics of it all, if there’s anything else someone would like to know about their behavior I’d be happy to answer. I just really need help.

We have a tile kitchen and my dog likes to lay down on the floor and she is beggining to show rashes on her elbows from the rubing of the tile on her skin. Is this a serous thing?

this is an instictual behavior, a throwback to when they were outside in the wild. They are trying to create a little dugout to surround and insulate them, keeping their bodyheat close.