Hello, im looking for web applications that have such function that prompt visitors for password before viewing the website, i would like to use applications like wordpress, joomla etc.

Anyone can advise ?

On windows machine you can use IISPassword application to make password protected website.
Also you can uncheck anonymous user access for site/virtual directory so this way it will prompt for login.

If your hosting is cPanel powered you can use the Password Protected directories feature to accomplish this.

If you are running apache webserver , you can use htaccess to enable password protection.

If you are using the apache then with the use of .htaccess and .htpasswd your
directory will get protected. When you will try to enter the directory you
will need password before logging in. Thus your website will become password
protected.